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