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

Reply via email to