Performance issue for version 3.9.2 compared with 3.16.2

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Performance issue for version 3.9.2 compared with 3.16.2

advancenOO
In order to profile sqlite 3.9.2 and sqlite 3.16.2, I run speedtest1.c on my
mobile phone.
It is weird to find that 3.9.2 is better than 3.16.2, especially in the
following case:
        “270, 10000 DELETEs, numeric BETWEEN, indexed"
        3.9.2 uses 0.7s while 3.16.2 uses 1.8s;

My relevant compilation options are shown below:
    -DSQLITE_THREADSAFE=1
    -DSQLITE_DEFAULT_AUTOVACUUM=1
    -DSQLITE_DEFAULT_PAGE_SIZE=4096
    -DSQLITE_DEFAULT_JOURNAL_SIZE_LIMIT=1048576

Further more, 3.16.2 performs better when I decrease the delete times from
10000 to 1000.
So is it expected? If not, then what might be the possible reason?

Thanks for your help.



--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Performance issue for version 3.9.2 compared with 3.16.2

Richard Hipp-3
On 10/17/17, advancenOO <[hidden email]> wrote:

> In order to profile sqlite 3.9.2 and sqlite 3.16.2, I run speedtest1.c on my
> mobile phone.
> It is weird to find that 3.9.2 is better than 3.16.2, especially in the
> following case:
>         “270, 10000 DELETEs, numeric BETWEEN, indexed"
>         3.9.2 uses 0.7s while 3.16.2 uses 1.8s;
>
> My relevant compilation options are shown below:
>     -DSQLITE_THREADSAFE=1
>     -DSQLITE_DEFAULT_AUTOVACUUM=1
>     -DSQLITE_DEFAULT_PAGE_SIZE=4096
>     -DSQLITE_DEFAULT_JOURNAL_SIZE_LIMIT=1048576
>
> Further more, 3.16.2 performs better when I decrease the delete times from
> 10000 to 1000.
> So is it expected? If not, then what might be the possible reason?

It is not expected.  In fact, it directly contradicts our on
measurements shown here: https://www.sqlite.org/cpu.html

I have no explanation for your anomalous result.

Aside:  This email originally went into Spam.  I only discovered it,
moments ago, while searching for a different message that had gone to
spam.
--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users