Re: SQL Benchmarking

Posted in 2003

Gorazd Hribar Rajteri�� — Tue, 11 Nov 2003 07:24:21 +0100 — source: Usenet: comp.databases.informix

Run two or more consecutive tests for each configuration. Discard results for first run. This should give you pretty fair picture. Gorazd "Brian Foster" <bc_foster@hotmail.com> wrote in message news:boogvf$1g517j$1@ID-78326.news.uni-berlin.de... > 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 > >

Related threads

Alter Fragment Problems with Serial8