Hello! On Wednesday 04 March 2009 17:19:09 Jim Wilcoxson wrote: > Have you tried changing the page size to 4096 or 8192? Doing this > with my SQLite application and increasing the transaction size > decreased runtime from over 4 hours to 75 minutes. The runtime for > my app writing the same amount of data to flat files was 55 minutes, > so the time penalty for building a database was about 35%, which > seemed reasonable. > > I haven't tried changing the cache size yet, because I like that my > app uses a small amount of memory.
I have my own build of SQLite with default page size 4096 and increased caches for server applications. For huge databases and SAS disks i'm use page size 16384. Best regards. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
