kamil wrote:
I want to preallocate disk space for database. I have only one table with ~1
milion entries, each entry takes about 30 bytes. Entries are added/removed
but there is some maximum number of items, which can be put into the table
at the same time. Is it possible to allocate a fixed disk space for such
database ? How large should it be ? If yes, then is there a better way to
create large files than massive insterts/deletes ?
Kamil,
See my previous post in the archives at
http://www.mail-archive.com/sqlite-users@sqlite.org/msg12121.html
This produces a database with a fixed number of records. You may want to
investigate turning autovacuum to eliminate unused space in the database
(though it does add some overhead that makes the database slightly larger).
Massive inserts are the best (only?) way to create a large database
file. Just make sure you batch your inserts in a transaction.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
