On Fri, Dec 28, 2012 at 3:34 PM, Dan Frankowski <dfran...@gmail.com> wrote:
> I am running a benchmark of inserting 100 million (100M) items into a > table. I am seeing performance I don't understand. Graph: > http://imgur.com/hH1Jr. Can anyone explain: > > 1. Why does write speed (writes/second) slow down dramatically around 28M > items? > 2. Are there parameters (perhaps related to table size) that would change > this write performance? > 3. Would horizontal partitioning (i.e. creating multiple tables, each for a different key range) help? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users