Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
Requestlive True or False |
Thu, Nov 29 2007 11:20 AM | Permanent Link |
"Jose Eduardo Helminsky" | Tim
I know the difference about live result set and canned result set very well. Sometimes when selecting data from table with more than 1M records is faster to choose canned result instead of live result. My doubt is: Is there any way to follow as a rule when I have to choose canned result instead of live ? Eduardo |
Thu, Nov 29 2007 4:17 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Eduardo,
<< My doubt is: Is there any way to follow as a rule when I have to choose canned result instead of live ? >> Selecting just a few rows from a very large table will almost always be faster with a canned result set than a live result set, especially if there is an ORDER BY clause that uses an available index. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Nov 30 2007 4:13 AM | Permanent Link |
"Jose Eduardo Helminsky" | Thanks
|
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |