Seebs wrote: > I tried ... an in-memory database. > What I observed was a very, very, large slowdown. > We're talking 10MB of database
That database would be in the OS's file cache anyway. > 3. It is dramatically reduced in degree by pragma page_size = 8192. The default cache size is measured in pages. So maybe your cache size is too small? > 4. It scales roughly with database size; at 28,000 rows, it's quite > noticeable, and at 84,000 it's painful. Sounds like some inefficent O(n²) algorithm. Could you show some example query? What is the EXPLAIN QUERY PLAN output? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
