I cannot see a reason for what you propose, but you could do it by brute
force and ignorance - populate the DB with 1 million rows then delete
them all to add all the space to the free pages list. Then your
insertions will use the freed pages, not fresh ones.
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 ?
Thanks in advance,
Kamil
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------