I had a similar experience: changing my page size decreased the run time of my SQLite application from 4 hours to 80 minutes (Linux).
I think it would be very good if the default page size was changed to 4096, at least for LInux builds. It makes a huge difference in performance. Jim On 2/17/09, Paolo Pisati <p.pis...@oltrelinux.com> wrote: > Alexey Pechnikov wrote: >> >> PRAGMA default_cache_size = 200000; >> pragma page_size=4096; >> vacuum; >> > > sqlite> pragma page_size; > 4096 > sqlite> PRAGMA default_cache_size; > 200000 > > p...@ferret:~/log_analyzer >date ; ./log_parser_ms_sqlite.pl 2 > vmta2-2009-02-16_1400-success.log.bz2.done.ec.ed ; date > Tue Feb 17 15:07:40 CET 2009 > Tue Feb 17 15:13:22 CET 2009 > > it's a 75% shave of application time, amazing!!! > > -- > > bye, > P. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Software first. Software lasts! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
