One more useful comparison. The following query is prepared and step is called with these results:
step: UPDATE RESPONSES SET RESPONSE_NAME = :RESPONSE_NAME WHERE RESPONSE_OID = :RESPONSE_OID Cumulative Allocated Memory: 10,992 Count of _malloc Calls: 18 Cumulative Reallocated Memory: 0 Cumulative Reallocated Memory where nil: 0 Count of _realloc Calls: 0 Count of _realloc Calls where nil: 0 Count of _free Calls: 18 Cumulative _mallocs by size <= 1kb: 1,704 bytes (9 count) 1kb to 4kb: 9,288 bytes (9 count) 4bk to 8kb: 0 bytes (0 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) Cumulative _reallocs by size <= 1kb: 0 bytes (0 count) 1kb to 4kb: 0 bytes (0 count) 4bk to 8kb: 0 bytes (0 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) Cumulative _reallocs of nil pointers by size <= 1kb: 0 bytes (0 count) 1kb to 4kb: 0 bytes (0 count) 4bk to 8kb: 0 bytes (0 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) step is called on the exact same prepared query 0.201 seconds later: Cumulative Allocated Memory: 439,424 Count of _malloc Calls: 2,248 Cumulative Reallocated Memory: 5,080 Cumulative Reallocated Memory where nil: 0 Count of _realloc Calls: 23 Count of _realloc Calls where nil: 0 Count of _free Calls: 2,246 Cumulative _mallocs by size <= 1kb: 175,160 bytes (2,047 count) 1kb to 4kb: 264,264 bytes (201 count) 4bk to 8kb: 0 bytes (0 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) Cumulative _reallocs by size <= 1kb: 5,080 bytes (23 count) 1kb to 4kb: 0 bytes (0 count) 4bk to 8kb: 0 bytes (0 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) Cumulative _reallocs of nil pointers by size <= 1kb: 0 bytes (0 count) 1kb to 4kb: 0 bytes (0 count) 4bk to 8kb: 0 bytes (0 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
