Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 12 of 12 total
Thread Tables vs Querys
Sat, Jul 24 2010 4:36 PMPermanent Link

Raul

Team Elevate Team Elevate

<<
<< Yes - switching to (live) query would result in less data being brought
down (2 vs 52 fields). >>

Actually, that's backwards - a canned query result set (non-live) will only
contain 2 fields, but live queries always contain the complete records.
>>

Thanks Tim,

I was not aware of that.

So one can either use live query and be hit with transfer cost of complete records (even if select contained only few fields) or use canned query and get hit by the temp table creation cost but save on data transfer.

Raul
Tue, Jul 27 2010 8:50 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Raul,

<< So one can either use live query and be hit with transfer cost of
complete records (even if select contained only few fields) or use canned
query and get hit by the temp table creation cost but save on data transfer.
>>

Yes, that is exactly correct.

--
Tim Young
Elevate Software
www.elevatesoft.com
« Previous PagePage 2 of 2
Jump to Page:  1 2
Image