On 29 Dec 2012, at 9:45pm, Michael Black <mdblac...@yahoo.com> wrote:

> During the 1M commit the CPU drops to a couple % and the disk I/O is pretty
> constant...albeit slow....

For the last few years, since multi-core processors have been common on 
computers, SQLite performance has usually been limited by the performance of 
storage.  Several times I've recommended to some users that rather than pouring 
their money and development effort into unintuitive programming (e.g. splitting 
one TABLE into smaller ones) they just update from spinning disks to SSD.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to