On 17 Aug 2010, at 1:13am, Paweł Hajdan, Jr. wrote: > Could you take a look at the original Chromium patch: > http://src.chromium.org/viewvc/chrome/trunk/src/third_party/sqlite/preload-cache.patch?revision=26596&view=markup? > > Is it something you'd like to include in SQLite? If so, does the patch need > any adjustments before that's possible?
Do you have any figures for testing, please ? In other words, do you have proof that in real world usage this does actually have some advantage ? If possible, produce figures for more than one OS, since Windows takes a great deal of advantage of read-ahead caching, whereas Unix gets hardly any increase in speed from it. Note that a fast million writes to a database is not a real-world situation. Chromium, for instance, is unlikely to ever write a million rows without pauses for reading. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users