On Fri, Jan 13, 2012 at 4:49 PM, John Elrick <john.elr...@fenestra.com>wrote:

>
> 3.6.17
>
> Procedure               % Time    Time        Calls
> _sqlite3_step           58.4%      1.79        5,052
> _memcpy                 22.8%      0.69    1,342,957
> _memset                  7.8%      0.24      465,299
> ...
> _malloc                  1.9%      0.06       95,505
>
>
> 3.7.9
>
> Procedure               % Time    Time        Calls
> _malloc                 56.9%     44.39    6,975,335
> _sqlite3_step           30.4%     23.68        5,052
> _memcpy                  4.8%      3.70    7,710,259
>

Very curious....

SQLite has lots of interfaces that can be used to determine performance and
status information.  Some example code from the command-line shell that
accesses this status information is here:
http://www.sqlite.org/src/artifact/aa4183d4a5243d?ln=990-1076

I would very much like to see some of these same stats from your
application.  Do you think you could add some code like that found in the
shell and give us some more insight into what is going on?


-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to