Addendum: This test was conducted using a full size test dataset. I had been using one that was an order of magnitude smaller for profiling before, but could use the full size for this test.
On Mon, Jan 16, 2012 at 4:37 PM, John Elrick <john.elr...@fenestra.com>wrote: > Lacking the status interfaces for 3.6.17 I was forced to mark them as > "interface not supported". Simon suggested I track the calls to _malloc, > so I've added extensive tracing code. Here is the final output from the > two versions: > > Application: Surveyor.exe > Sqlite version: 3.6.17 > Date/Time: 01/16/2012 16:32:18 > Memory Used: interface not supported > Page Cache Used: interface not supported > Page Cache Overflow: interface not supported > Number of Scratch Allocations Used: interface not supported > Scratch Overflow: interface not supported > Largest Allocation: interface not supported > Parser Stack: interface not supported > Largest Pcache Allocation: interface not supported > Largest Scratch Allocation: interface not supported > Number of Outstanding Allocations: interface not supported > Lookaside Slots Used: interface not supported > Pager Heap Usage: interface not supported > Schema Heap Usage: interface not supported > Statement Heap/Lookaside Usage: interface not supported > Successful lookaside attempts: interface not supported > Lookaside failures due to size: interface not supported > Lookaside failures due to OOM: interface not supported > Page cache hits: interface not supported > Page cache misses: interface not supported > Cumulative Allocated Memory: 892,318,312 > Count of _malloc Calls: 1,072,825 > Count of _free Calls: 1,070,971 > Cumulative _mallocs by size > <= 1kb: 109,025,904 bytes (565,230 count) > 1kb to 4kb: 510,357,112 bytes (485,801 count) > 4bk to 8kb: 48,005,376 bytes (11,610 count) > 8bk to 16kb: 605,208 bytes (47 count) > 16bk to 32kb: 224,272,704 bytes (10,136 count) > 32bk to 64kb: 52,008 bytes (1 count) > 64bk to 128kb: 0 bytes (0 count) > 128kb to 256kb: 0 bytes (0 count) > 256kb to 512kb: 0 bytes (0 count) > 512kb to 1024kb: 0 bytes (0 count) > > 1mb: 0 bytes (0 count) > > Application: Surveyor.exe > Sqlite version: 3.7.9 > Date/Time: 01/16/2012 16:35:01 > 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 > Number of Scratch Allocations Used: 0 (max 0) > Scratch Overflow: 0 (max 24,880) bytes > Largest Allocation: 500,042 bytes > Parser Stack: 0 > Largest Pcache Allocation: 4,232 bytes > Largest Scratch Allocation: 24,880 bytes > Number of Outstanding Allocations: 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 > Cumulative Allocated Memory: 932,315,928 > Count of _malloc Calls: 69,859,114 > Count of _free Calls: 69,857,292 > Cumulative _mallocs by size > <= 1kb: 1,118,058,528 bytes (63,640,300 > count) > 1kb to 4kb: 3,836,490,296 bytes (6,197,060 count) > 4bk to 8kb: 47,800,672 bytes (11,571 count) > 8bk to 16kb: 597,016 bytes (46 count) > 16bk to 32kb: 224,272,704 bytes (10,136 count) > 32bk to 64kb: 64,008 bytes (1 count) > 64bk to 128kb: 0 bytes (0 count) > 128kb to 256kb: 0 bytes (0 count) > 256kb to 512kb: 0 bytes (0 count) > 512kb to 1024kb: 0 bytes (0 count) > > 1mb: 0 bytes (0 count) > -- John Elrick Fenestra Technologies 540-868-1377 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users