----- Original Message -----
From: "Geoff Simonds" <[EMAIL PROTECTED]>
My table contains about 500,000 rows and 4 columns, not all that much
data. The overall size of the db file is 35 mb. Does 15 - 20 seconds
sound right to load from disk into memory?
I can't tell you that until the following are answered:
1. What's the query?
2. What's the database schema? Indexes?
3. Are you calling prepare/step/finalize to load the data or using some
other method?
4. How are you storing the data in memory? linked lists? Pre-allocated
array?
The first two are the most important factors.
Robert
