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 observed is that we have a number of tables that have the same primary key (o_id). Each table has exactly the same number of entries and the a record corresponding to a particular o_id is stored at the same _row_id_ in each table. I was wondering if there is a way to use this information to remove some of the indexes without affecting the query speed much? 3. We are also storing multiple indexes on the same table to accommodate the different queries that exist. We are re-organizing the indexes again to ensure that we have indexes in the correct sequence to reduce the number of indexes we need to store. 4. Any other tips to keep the database smaller? Best Regards, Mohit. 3/2/2011 | 10:55 AM. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
