On Mon, 16 Feb 2009 20:02:11 -0800 (PST), jaya_kumar <jayakumar.ananthakrish...@wipro.com> wrote in General Discussion of SQLite Database <sqlite-users@sqlite.org>:
> >Hi All, > >In the following use case, when I try to update the following number of >objects SQLite DB file size is very large > >1. 1k object - DB file size was 264 Kb >2. 41k object - DB file size was 11 Mb >3. 100k object - DB file size was 26 Mb > >Is there any way to reduce the DB file size? Try this: - Reduce redundant data by strict normalisation of the database schema - Do not define indexes that are seldomly used - Try to use integers as primary key, make it the first column, and use the exact code CREATE TABLE tablename ( columnname INTEGER PRIMARY KEY, .... ); - Do not store data that you don't need >Thanks in advance, >Jai Good luck. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users