Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Speed / Caching |
Thu, Jan 18 2007 7:19 PM | Permanent Link |
"Adam H." | Hi,
More curiosity than anything, but I notice that if I open up DBSys, and perform a query with a number of joins - if no query has been run prevous, it takes about 4 times as long to execute, than if I have previously run the query. (ie - if I execute the query, the first time it may take 2 seconds, and if I re-run the query, it may only take 0.5secs from then onwards). Is this caching at work? (Running Local mode, executing sql on tables on the same PC as DBSys - ie no network). Thanks & Regards Adam. |
Fri, Jan 19 2007 1:57 AM | Permanent Link |
Sam Lawrence | Adam,
I'm pretty sure it's Window's caching. Sam |
Fri, Jan 19 2007 4:46 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
Unless you unprepare the query this is exactly what you'd expect, and then as Sam says there's Windows Roy Lambert |
Fri, Jan 19 2007 3:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Adam,
<< Is this caching at work? >> Yep. As Sam says, it is Windows caching the data. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |