Re: [sqlite] Optimizing Database Size

2011-02-02 Thread Mohit Sindhwani
Hi Simon, >> 1. We are already using CEROD, so the final database is compressed. >> >> 2. We ran the sqlite_analyzer and identified the tables that take up a >> lot of space and are now re-organizing the schema. One thing I observed >> is that we have a number of tables that have the same primary

Re: [sqlite] Optimizing Database Size

2011-02-02 Thread Simon Slavin
On 3 Feb 2011, at 2:58am, Mohit Sindhwani wrote: > 1. We are already using CEROD, so the final database is compressed. > > 2. We ran the sqlite_analyzer and identified the tables that take up a > lot of space and are now re-organizing the schema. One thing I observed > is that we have a numbe

[sqlite] Optimizing Database Size

2011-02-02 Thread Mohit Sindhwani
Hi All, I'm facing an issue where we want to make the database size smaller than it is. 1. We are already using CEROD, so the final database is compressed. 2. We ran the sqlite_analyzer and identified the tables that take up a lot of space and are now re-organizing the schema. One thing I obs