Thanks Richard and Petite,
On 9/10/2011 1:05 AM, Richard Hipp wrote:
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.
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,.
Richard: The page size is indeed changed to 8KB in one of the final
steps before we pack it up with CEROD - and it does help with the
database size!
Petite: thanks for pointing that out - we'll drop the index on the
primary key!
Both these suggestions will help.
I'm still trying to see if we make use of the fact that some data can be
sorted... I can't find the best example to illustrate the need for it..
Let me see if I can find something that explains it better. As an
example, if we had something like
create table titles (id integer primary key, title text, ...);
could we sort the records by title and use that in some way to restrict
the search space when searching titles starting with a specific letter?
Thanks,
Mohit.
9/10/2011 | 6:13 PM.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
