SQLite Forum

Out of Memory Errors - Possible Enhancement
Login
I am sorry, for some reason, I don't get the ability to edit my previous post.  In the preview, it looked fine, but once I posted, all the line breaks went away for some reason.

Here is a better formatted post with the same information.  Hope this goes through without getting chewed up.
<code>
Enter ".help" for usage hints.
sqlite> .timer on
sqlite> .stats on
sqlite> .mode list
sqlite> select * from tripsummary;
Memory Used:                         23325376 (max 1317885864) bytes
Number of Outstanding Allocations:   163442 (max 553284)
Number of Pcache Overflow Bytes:     1995912 (max 357575560) bytes
Largest Allocation:                  9830400 bytes
Largest Pcache Allocation:           4256 bytes
Lookaside Slots Used:                120 (max 123)
Successful lookaside attempts:       463
Lookaside failures due to size:      91357
Lookaside failures due to OOM:       5740027
Pager Heap Usage:                    2075736 bytes
Page cache hits:                     4523979
Page cache misses:                   153425
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   1603936 bytes
Statement Heap/Lookaside Usage:      19168912 bytes
Fullscan Steps:                      2171004
Sort Operations:                     1882
Autoindex Inserts:                   1396736
Virtual Machine Steps:               288595597
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        19168912
Run Time: real 52.945 user 28.267381 sys 6.583242
Error: out of memory
sqlite>

</code>