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