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 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.
Thanks for the reply. We are a bit concerned that merging everything into a single table will increase the query times further... especially because we have blob fields in the tables too. I guess we will need to: * Merge all always-populated fields into a single table * Separate sparsely populated fields into a separate table * Separate blobs into different table(s) Cheers, Mohit. 3/2/2011 | 11:51 AM. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
