On 3/12/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote:
I'm converting a bunch of databases from SQLite 2.8.16 to SQLite
3.3.13 and am seeing something pretty amazing space saving. So good
that it might be too good to be true!
For example, a 17 meg database is cut down to 7 megs. That's fantastic
if it's just that SQlite is *that* much better at storing the data,
but I'm worried I'm missing things. The row counts for all the tables
match up but it will take more time for me to write something that
compares every field in every data table (there are more than 300
fields total in this database).
So is a 60%ish reduction in DB size from 2.8.16 to 3.3.13 normal?
did you get all your indexes over? they are the ones that take up a
bunch of space. Make sure you have all the indexes, and then run
ANALYZE. You will get a more final sense of space saving at that
point. There may or may not be any space saving, and unless you are
writing something for a floppy disk, what's the point of getting
excited over 10 Mb? My $25 thumbdrive is 2 Gb!
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
---------------------------------------------------------------------
collaborate, communicate, compete
=====================================================================
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
