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