Hi! >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. I had such example. I had records which were taking just a bit more than half of the page, so that the second half of the page was just wasted. This gives around 100% overhead. I've changed the page size to be much larger and the problem almost disappeared, but such database requires modified version of sqlite. It would be great if a newer version of sqlite will be able to create databases with the specified page size and to detect that page size on opening (or at least open the database with explicitly specified page size). Mikhail --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
