database cache /

[Ed Lazor]

I have a 400mb database.  The first query to tables takes about 90 seconds.
Additional queries take about 5 seconds.  I wait a while and run a query
again; it takes about 90 seconds for the first one and the rest go quickly.
I'm guessing data is being loaded into memory which is why things speed up.

Does this sound right?  Is there a way to keep the table in memory?  Nothing
is changing in the data.

Thanks,

-Ed