On Fri, Oct 7, 2011 at 12:30 PM, Mohit Sindhwani <m...@onghu.com> wrote:
> Hi All, > > I have been trying to see how we can make one of our databases more space > efficient. I am now looking at seeing if we have the right indexes and if > there is a way to save space by removing indexes. > Have you run the sqlite3_analyzer.exe utility (available from http://www.sqlite.org/download.html) on your database to see how efficiently the data is being stored and which tables are taking up the most space? Can you share the output of sqlite3_analyzer.exe with us? > > Is there some way to make use of the fact that the data can be sorted by a > specific column in the desired order before it is imported into the table, > or do we need to create an index on that column anyway? Eliminating the > index could save us space. One of the things in our case is that the data > is in a read only database (and further compressed/ encrypted by CEROD). > > Any ideas? > > Best Regards, > Mohit. > 8/10/2011 | 12:29 AM. > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
