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 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?
The best way to save space on that would be to merge the tables into one. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
