Richard, I don't know if the calls to _realloc will help also, but I've added tracing for those also. My updated output:
Application: Surveyor.exe Sqlite version: 3.7.9 Date/Time: 01/16/2012 17:20:58 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 Cumulative Reallocated Memory: 931,150,680 Count of _realloc Calls: 69,856,395 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) Cumulative _reallocs by size <= 1kb: 1,117,392,608 bytes (63,637,756 count) 1kb to 4kb: 3,836,372,120 bytes (6,196,954 count) 4bk to 8kb: 30,800 bytes (6 count) 8bk to 16kb: 0 bytes (0 count) 16bk to 32kb: 0 bytes (0 count) 32bk to 64kb: 0 bytes (0 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
