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
