Kazuho Oku wrote:
Unfortunately, my apache module only performs a single SELECT clause of
which WHERE clause can be indexed.
What I am wondering is the way to stop calling SQLite each time the module
processes an HTTP request (eliminate the FLOCK -> READ -> FUNLOCK done by
SQLite).
I think you are asking for SQLite to preserve its memory cache
and not reload pages from the disk as long as the database is
unchanged.
SQLite version 2.8 does not support this and probably never will.
The file format for SQLite version 3.0 was designed to support
a persistent cache. A counter was added to page 0 of the database
that increments whenever the database changes. So a reader process
can check this counter to see if it needs to reread the disk.
The code is in place to increment the counter, but the code to
check the counter and avoid the reload has not yet been added.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
