Compact?

[Ruslan Zasukhin]

on 2/6/04 4:14 AM, Ken Ray at kray at sonsothunder.com wrote:

>> You always can do, and should do
>>     
>>     SELECT FirstName, MiddleName, InsertedField, LastName
>> 
>> But not 
>>     
>>     SELECT *
> 
> So the suggestion is to type hundreds of extra characters every time I
> do a query when a single character will do? Some of my tables have 30
> fields or so, and I need every one of them in my query, and I have
> dozens of queries in my application... although this may make sure I
> don't have a problem when new fields are added, it's a real pain in the
> neck.

Well, this is general recommendation for SQL.

Another point.

IF you always do SELECT *, then you have potential for speed up!

RULE: the less fields you SELECT, -- the faster will be cursor.
    If you have table with 30 fields,
    but you select just 3 fields,
    the cursor will scroll 10 times faster.

 
> I'm going to stay with my kludge until a better solution comes down the
> pike some time in the future.
> 
> Thanks for the suggestion, though,
> 
> 
> Ken Ray
> Sons of Thunder Software
> Email: kray at sonsothunder.com
> Web Site: http://www.sonsothunder.com/

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------