Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Speed / Caching
Thu, Jan 18 2007 7:19 PMPermanent 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 AMPermanent Link

Sam Lawrence
Adam,
       I'm pretty sure it's Window's caching.

Sam
Fri, Jan 19 2007 4:46 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image