|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|
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
(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
Thanks & Regards
|Fri, Jan 19 2007 1:57 AM||Permanent Link|
I'm pretty sure it's Window's caching.
|Fri, Jan 19 2007 4:46 AM||Permanent Link|
Unless you unprepare the query this is exactly what you'd expect, and then as Sam says there's Windows
|Fri, Jan 19 2007 3:41 PM||Permanent Link|
Tim Young [Elevate Software]
Elevate Software, Inc.
<< Is this caching at work? >>
Yep. As Sam says, it is Windows caching the data.