I don't know of a daemon, but based on someone else's post where they described keeping a pool of sqlite3* handles to the database, and always reusing the most recently used handle first (so that the SQLite page cache is most likely still valid) I saw a very big jump in performance.
Perhaps that would help in your case too? > -----Original Message----- > From: Alexander Batyrshin [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 24, 2008 7:38 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Cache for SQLite > > Hello All, > I've used SQLite for half of year and find it perfect. > But for my case (web-site) there is a gap in feature like cache. > I know that file-system cache do a lot of work for SQLite, but it is > still not perfect. > For example IMHO it's possible to crate something like "daemon" which will be > between application and SQLite engine and which will do caching. > > Do you know any extensions/modification/patch that allow to add cache feature? > > -- > Alexander Batyrshin aka bash > bash = Biomechanica Artificial Sabotage Humanoid > > ---------------------------------------------------------------------------- - > To unsubscribe, send email to [EMAIL PROTECTED] > ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
