I am trying to find the peak heap usage for creating a table with few entries and when calculated the peak heap usage increases as the numbers of items inserted into the table increases.
Following are the steps done, 1. Table created 2. Table updated by insert statement 3. Query for a single tupple from the table based on a primary key Please find below the heap usage when sqlite was operated in file mode, 1k entries - 315 Kb 10k entries - 2.3 Mb 100k entries- 5.7 Mb Please find below the heap usage when sqlite was operated in memory mode (using ":memory:"), 1k entries - 318 Kb 10k entries - 11.6 Mb 100k entries- 29.6 Mb I am newbie to SQLite, so please let me know if these figures are expected for SQLite. Also please let me know why is the heap usage increasing based on the total number of entries updated to the database? Thanks in advance, Jai -- View this message in context: http://www.nabble.com/SQLite--Memory-heap-usage-query-tp21989418p21989418.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
