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? > > Richard, per your request: Memory Used : 7,905,536 (max 8,582,104) bytes Page Cache Used : 0 (max 0) pages Page Cache Overflow : 6,910,576 (max 6,911,600) bytes Scratch Used : 0 (max 0) Scratch Overflow : 0 (max 24,880) bytes Malloc Size : 500,042 bytes Parser Stack : 0 Page Cache Size : 4,232 bytes Scratch Size : 24,880 bytes Malloc Count : 5,835 (max 6,499) Lookaside Slots Used : 500 (max 500) Pager Heap Usage : 6,873,408 bytes Schema Heap Usage : 39,560 bytes Statement Heap/Lookaside Usage: 806,592 bytes Successful lookaside attempts : 4,888 Lookaside failures due to size: 3,782,307 Lookaside failures due to OOM : 4,090,019 Page cache hits : 2,585,425 Page cache misses : 0 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users