On 19 Sep 2011, at 7:13pm, Jaco Breitenbach wrote: > While on the topic of performance, I've performed a test in which new tables > were created within an active transaction (manual 'partitioning') and > populated within the same transaction. What I've found, was that as the > number of tables created within the transaction increased,
You mean 'tables' or 'rows' ? > the performance > of the inserts within the same transaction decreased significantly. I > haven't spent any further time trying to analyze the cause for this apparent > behaviour. Because it has to do more work. Inserting the 10,000th record requires comparing it with 10,000 others to see whether it's a duplicate. Inserting the 20,000th record requires twice as many comparisons. It's not a linear function, since the comparison is done by searching a tree rather than a list, but that's a big component of it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users