Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 11 to 12 of 12 total |
Tables vs Querys |
Sat, Jul 24 2010 4:36 PM | Permanent Link |
Raul 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, May 15, 2024 at 08:40 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |