"Zhang Cheng-E7104C" <[EMAIL PROTECTED]> wrote:
> I want to reserve a specific size for every database when it is
> created.
> Is that possible?
>
This will only work if you do NOT enable auto-vacuum. To
repeat: auto-vacuum must be switched off.
When you create the database, create a table and start inserting
bogus data into that table:
CREATE TABLE t1(x);
INSERT INTO t1 VALUES(randomblob(900));
Repeat the INSERT until your database is the desired size.
Then do:
DROP TABLE t1;
The size of the database file will not decrease. But the disk
space formerly allocated to the T1 table will become available
for reuse.
You can use this technique to create a database template on
a workstation then transfer the template database over to your
embedded device, if you want.
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
