Paolo Pisati wrote: > any other idea i could apply to squeeze some more performance? > > increasing cache_size helps:
PRAGMA 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 12:46:55 CET 2009 Tue Feb 17 13:00:32 CET 2009 any other hint? -- bye, P. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
