On Mon, 16 Feb 2009 20:02:11 -0800 (PST), jaya_kumar
<[email protected]> wrote in General
Discussion of SQLite Database <[email protected]>:
>
>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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
