SQL Benchmarking

Posted in 2003

Brian Foster — Mon, 10 Nov 2003 12:20:44 -0500 — source: Usenet: comp.databases.informix

Hi, how can I ensure that data is being read from disk rather than from the buffer? I am moving data between 2 database instances (with insert/select)and would like to compare performance relative to differing configurations/settings. thanks! -Brian

↪ replying to Brian Foster

Art S. Kagel — Mon, 10 Nov 2003 14:13:43 -0500 — source: Usenet: comp.databases.informix

On Mon, 10 Nov 2003 12:20:44 -0500, Brian Foster wrote: The only way is to shutdown the instance between tests. Hmm, or set BUFFERS way low and run a purging query that will flood the buffers with data from some other table/database between runs. Art S. Kagel > Hi, > > how can I ensure that data is being read from disk rather than from the > buffer? I am moving data between 2 database instances (with insert/select)and > would like to compare performance relative to differing > configurations/settings. > > thanks! > > -Brian