On Wed, 2005-03-02 at 16:53 -0800, R S wrote: > I periodically delete older records from my table (which contains > hundreds of thousands of entries). I want to reindex the table for > more efficient access. >
That is fully automatic in SQLite. REINDEX does not help. REINDEX is only needed if you change a collating sequence. After a lot of INSERTs and DELETEs, you can sometimes get slightly better performance by doing a VACUUM. VACUUM improves locality of reference slightly. -- D. Richard Hipp <[EMAIL PROTECTED]>
