> 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!!! > > -- > If you really have to have even more performance, you could cache inserts in RAM and wrap multiple INSERTS with a single transaction when you have a certain number cached (or if a max delay is reached).
I noted that you were willing to consider PRAGMA synchronous = OFF so I assume that you could tolerate a little data loss in case of a crash. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
