Jakub Adamek wrote: > My experience is that SQLite makes roughly about 3x bigger files than MS > Access. How would this change in 3.0? >
SQLite is very storage efficient in the common case. In a typical table, SQLite will use about 4 or 5 bytes of disk space for every 3 bytes of actual data stored. Put another way, about 60% to 75% of an SQLite database file is the actual data being stored and the other 40% to 25% is overhead.
If you have an example where the overhead is significantly larger than this, I'd be interested in seeing it.
The new version 3.0 file format is anticipated to reduce overhead by about 5%. YMMV, of course.
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
