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. (It might endanger the integrity of your database, of course, to leave this setting for production use.) ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------