Thanks for the reply. You are right we should VACUUM in cases where we are removing items. But, this question is not about removing. This question is about a fully populated database and it seems bloated to be occuping 3 times the memory. Maybe this amount of memory is considered normal since we are using SQL and sqlite. Just wanted to check if that is in fact the case.
On 12/17/09 9:48 AM, "Kurt D. Knudsen" <kknud...@zystemsgo.com> wrote: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
