Referencing the C program I sent earlier....I've found a COMMIT every 1M records does best. I had an extra zero on my 100,000 which gives the EKG appearance. I averaged 25,000 inserts/sec over 50M records with no big knees in the performance (there is a noticeable knee on the commit though around 12M records). But the average performance curve is pretty smooth. Less than that and you're flushing out the index too often which causes an awful lot of disk thrashing it would seem. During the 1M commit the CPU drops to a couple % and the disk I/O is pretty constant...albeit slow....
P.S. I'm using 3.7.15.1 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users