John Elrick wrote:
Griggs, Donald wrote:
John Elrick wrote:
"what the heck is happening that is creating a better than order of
magnitude difference in execution time on five out of seven Windows
machines?".
John,
If the database is opened and closed just once for your testing, I think
you can find out if buffer flushing is involved by *temporarily*
adding
Pragma synchronous=OFF;
At the beginning of your test.
Thanks Donald. The results are now identical. So, it has to do with
buffer flushing differences between the machines. Now I have to
figure out what the differences are given that the XP laptop is
configured as shipped and is showing the performance improvement.
Addendum. I have confirmed that write caching is enabled for both the
"slower" and "faster" machine. So, I can eliminate write caching as
being the difference.
John
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
