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
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