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) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
