On Tue, 10 Sep 2013 12:58:21 +0000
Harmen de Jong - CoachR Group B.V. <har...@coachr.com> wrote:

> I think the way I wrote our timings were not that clear, since they
> are definately exponentially. The numbers from my previous post refer
> to the multiplier between the test cases. Just to make it clear, here
> follows the same tests, but then expressed in msec of total time per
> test.
> 
> 500 tables - 10 msec in total
> 1000 tables - 25 msec in total
> 5000 tables - 298 msec in total
> 10000 tables - 985 msec in total

I don't know what you mean by "exponentially".  

        500  .020 ms/table
        1000 .025 ms/table
        5000  .0596 ms/table
        10000 .0985 ms/table

Linearly, I'd say.  It may help to look at it graphically.  

        http://www.schemamania.org/sqlite/graph.pdf

> we cannot find anything in there that would explain an exponential
> groth in time.

I doubt you will.  

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

Reply via email to