From: "D. Richard Hipp" <[EMAIL PROTECTED]> > Kazuho Oku wrote:
> 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. This sounds great! Do you have any plans to add the code that checks the version before reloading data? Or else, could you provide a function that returns value of the counter? I think such a function would be useful not only for me but in some areas, for example: a daemon monitoring a SQLite database. # BTW, is the counter the one updated by pager_incr_changecounter?
