Re: [sqlite] SQLite- Memory heap usage query

On Tue, 17 Feb 2009 19:11:56 +0100, Kees Nuyt wrote in sqlite-users@sqlite.org: I'm not fond of replying to myself, but this needs some clarification: >- Try to use integers as primary key, > make it the first column, << wrong > and use the exact code > CREATE TABLE

Re: [sqlite] SQLite- Memory heap usage query

On Mon, 16 Feb 2009 20:02:11 -0800 (PST), jaya_kumar wrote in General Discussion of SQLite Database : > >Hi All, > >In the following use case, when I try to update the following number of >objects SQLite DB file size is very large >

Re: [sqlite] SQLite- Memory heap usage query

Didn't you ask this question 4 days ago, and it was answered? The only difference in your question this time around seems to be that you are asking for a way to reduce the db file size. You could utilize a compression library on your data... check the mail archives and also google for that

Re: [sqlite] SQLite- Memory heap usage query

Hi All, In the following use case, when I try to update the following number of objects SQLite DB file size is very large 1. 1k object - DB file size was 264 Kb 2. 41k object - DB file size was 11 Mb 3. 100k object - DB file size was 26 Mb Is there any way to reduce the DB file size? Thanks

Re: [sqlite] SQLite- Memory heap usage query

On Thu, 12 Feb 2009 19:14:44 -0800 (PST), jaya_kumar wrote in General Discussion of SQLite Database : > >I am trying to find the peak heap usage for creating a table with few entries >and when calculated the peak heap usage increases

[sqlite] SQLite- Memory heap usage query

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