I did, but the schema is about 4 times smaller than the DB file; also
the SQL script should be more comprimable than the db file.
This is obvious, because the db file also contain the SQL schema
queries, so it must be larger than the only SQLite schema :)
Paolo
I think you have to do some VACUUM'ing in order to shrink the database.
--Keith
-----Original Message-----
From: Paolo Vernazza [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 9:56 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] .db file size is not changing
Unnikrishnan Nair wrote:
Hi all,
I have a sqlite database. I had thousands of rows in
it. I did a test with the database and everything was
good. So before I ship it to production, I went to the database and I
did drop all the index and 'deleted' all the rows from the table. I
thought the size of the database will come down so that I can ship the
model database for production. But the size didn't change.
How can I reduce the size or is it possible at all?
Thanks.
Unni
I think that it is better let your program create the DB structure from
a sql schema script.
Usually it is smaller than the corresponding DB..
sqlite data.db .schema > schema.sql
Paolo
