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