Re: [boost] Boost.SQL, SOCI and beyond

From: Jeremy Day (jeremy.day_at_[hidden])
Date: 2006-10-06 12:05:15

On 10/6/06, james.jones_at_[hidden] <james.jones_at_[hidden]>
wrote:
>
> Surely you mean "... NOT using select *..."? I've always considered it a
> best practice not to use select * in any production code. Is there another
> perspective on this?

It is my understanding that "select *" is generally less efficient than
specifying the fields to select.  Not to mention that if you are relying on
select * to return fields in a specific order, and that order changes,
you're in for some hard to find bugs.

Jeremy