Did you try to VACUUM the database? When items are removed from the database, the size doesn't shrink, it just marks the pages as free. Correct me if I'm wrong.
Kurt -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kavita Raghunathan Sent: Thursday, December 17, 2009 10:44 AM To: Discussion of SQLite Database Cc: Kelvin Xu Subject: [sqlite] Using sqlite3: Excess memory consumed ? Hi, We have a pressing need to reduce memory consumption. Your help is appreciated. We have a database 672 tables, all with the same layout: 2 columns of 4 bytes each and 186 rows. Theoretically, the memory consumed should be: 672 * (2 *4 * 186) = 999936 Bytes ~= 1.0 MB However, the actual memory consumed is 4.2MB Is the difference due to overhead of using Sqlite3 ? Can you recommend ways for us to cut down? Thanks for your input, Regards, Kavita & Skyfiber team ===========================More Info about our database==================== All 672 tables look like this: Example Row below Index(4 bytes) Value(4 bytes) 0x11111111 0x22222222 _______________________________________________ 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
