On Aug 18, 2008, at 4:38 PM, Darren Landrum wrote: > Every touch of a GUI widget will result in a query > run on the database, so it's best that that be in memory, I think.
Have you actually run experiments to see if this is the case, or are you just guessing? My guess would be the combination of the OS disk cache and SQLite's internal page cache will make actual disk I/O relatively rare, even for an on-disk database. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users