Re: [Hsqldb-user] "benchmark" failure through file cache?

[fredt <fr...@us...>]

First of all, operating system caching plays a part. I don't know how to 
disable this.

To change HSQLDB's internal cache size, you should read the Guide on the 
cache_scale property.

Fred
----- Original Message ----- 
From: "Detlef Rudolph" <ru...@gm...>
To: <Hsq...@li...>
Sent: 16 January 2008 22:00
Subject: [Hsqldb-user] "benchmark" failure through file cache?


Hello Listmembers,

i try to tune some SELECT Statements. I have the
effect that although my Test runs as JUnit-Task
which open connection to hsqldb (cached table),
runs the SELECT and close the connection, the
first run needs more time than following runs.
Only after reboot i have a Time consumption as
in first run. I think it is the file system cache
that plays me a trick.

Can you give me a hint, how i can dupe the file
cache? I tried to read a large file between two
runs, but that doesn't help. I have no Admin rights
to change cache sizes or so.

Thanks for your answer,
Det

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hsqldb-user mailing list
Hsq...@li...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user