On Wed, Sep 1, 2010 at 12:46 PM, Jay A. Kreibich <j...@kreibi.ch> wrote: > On a personal level, I don't think it is worth it. In the end, you're > still hoping the OS and filesystem will make smart choices about block > allocations. An application shouldn't need to be spending a lot > of time worrying about this level of filesystem performance. No > matter what, you're just hinting and setting up conditions that > should allow the filesystem driver to do something smart and fast. > It may, or it may not, actually do so. Right, but giving it more hints means it's more likely to do the smart and fast thing. For what it's worth, Taras is working on improving the performance of SQLite in Firefox. He has data that shows that this can dramatically reduce the number of page faults (Taras, please correct me if I'm misrepresenting things) when loading the database. These leads to faster startup times of Firefox.
Cheers, Shawn Mozilla Developer _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users