On Sat, May 30, 2009 at 07:01:31PM +0100, Simon Slavin wrote: > I'm interested in how sqlite works differently to the SQL systems > which keep a daemon running as a background task. One of the > advantages of having a daemon which persists between runs of an > application is that the daemon can keep its own list of ORDERs, and > JOINs which are asked for frequently, and decide to maintain them even > when no SQL-using application is running. [...]
You don't need a daemon to do that. One could use a special table in the database itself (much like the master table) to keep statistics about all sorts of things. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users