Hi, After running my query : Memory Used: 131655360 (max 131656000) bytes Number of Outstanding Allocations: 2079 (max 2081) Number of Pcache Overflow Bytes: 131567752 (max 131567752) bytes Number of Scratch Overflow Bytes: 0 (max 0) bytes Largest Allocation: 65784 bytes Largest Pcache Allocation: 65784 bytes Largest Scratch Allocation: 0 bytes Lookaside Slots Used: 18 (max 36) Successful lookaside attempts: 76 Lookaside failures due to size: 19 Lookaside failures due to OOM: 0 Pager Heap Usage: 131536576 bytes Page cache hits: 2 Page cache misses: 5298 Page cache writes: 0 Schema Heap Usage: 2536 bytes Statement Heap/Lookaside Usage: 4016 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0
Then I ran "Pragma shrink_memory" Memory Used: 152584 (max 131658680) bytes Number of Outstanding Allocations: 79 (max 2081) Number of Pcache Overflow Bytes: 65536 (max 131567752) bytes Number of Scratch Overflow Bytes: 0 (max 0) bytes Largest Allocation: 65784 bytes Largest Pcache Allocation: 65784 bytes Largest Scratch Allocation: 0 bytes Lookaside Slots Used: 3 (max 36) Successful lookaside attempts: 80 Lookaside failures due to size: 22 Lookaside failures due to OOM: 0 Pager Heap Usage: 66344 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Schema Heap Usage: 2536 bytes Statement Heap/Lookaside Usage: 1408 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 On Mon, Oct 28, 2013 at 6:51 PM, Richard Hipp <d...@sqlite.org> wrote: > On Mon, Oct 28, 2013 at 9:16 AM, Raheel Gupta <raheel...@gmail.com> wrote: > > > >> Whether or not free() returns that space to the operating system or > > keeps > > it around to satisfy future malloc() calls is a detail of the > > implementation of free(). > > > > Sir, anyway to be sure of that ? > > > > In the command-line shell, do ".stats on". Then run your commands. > Monitor the "Memory Used:" and "Number of Outstanding Allocations:" > answers. What do they tell you? > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
