On Fri, Jan 13, 2012 at 5:58 PM, Richard Hipp <d...@sqlite.org> wrote:

> 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?


Thanks for the direction.  I'll start working on it on Monday.


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

Reply via email to