On Fri, Oct 7, 2011 at 12:30 PM, Mohit Sindhwani <[email protected]> wrote:
> Hi All,
>
> I have been trying to see how we can make one of our databases more space
> efficient.
Have you tried increasing the page size? You seem to currently be using
1024-byte pages. Try increasing that to 4096 or 8192. You might get both a
performance increase and a database size reduction.
PRAGMA page_size=8192; VACUUM;
The VACUUM might take a little while on your database,.
> I am now looking at seeing if we have the right indexes and if there is a
> way to save space by removing indexes.
>
> 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
> [email protected]
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
>
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
