V4RB - 8.6, 9.22 Initial Query Slowdown

[Fitzbew at aol.com]

The first time I run a complex query with my app in OS 8.6 and 9.2.2 (both 
carbon and Classic compilations), the process takes 9-10 clock seconds.  Running 
the same query again, immediately afterward, takes just a second or so.  I 
can close my app, and relaunch it and then run the exact same query --- it takes 
just a second or so.  If I restart the Mac, and then relaunch the 
application and run the same query --- it takes 9-10 seconds again the first 
time.  ALL subsequent queries are blazing fast.  Just the first one after each 
restart is slow.  The app runs many queries during launch, but none are 
complicated (no joins, etc..).  Happens with the machine's virtual memory on and 
off.

The "process" involved just posts recordset contents to a grid --- I've ruled 
out the grid as the cause.

This db file was initially created using mode 1 (just one file).

I assume this is some kind of cache-building issue --- any suggestions as to 
how I can make the initial query run as fast as subsequent queries?  I've 
experimented with increasing the cache size in ValentinaInit, but it hasn't helped 
so far.  

(Why doesn't this happen in OS X ?)

Hardware is DP 800 with 384 megabytes of RAM.  Lots of free hard drive space.

Russ