Subject | RE: [firebird-support] Re: Controlling expansion of database file / grow-by option? |
---|---|
Author | Leyne, Sean |
Post date | 2005-06-02T15:23:45Z |
> I am still curious if this feature exists or if people think it wouldI don't.
> provide any benefits...
Disk fragmentation is not under application control, it is entirely
something which the OS and the file system are responsible for.
The reason that other DB/applications allow for the expansion to be
controlled is to minimize the number of OS calls required when databases
are growing in size. Allocating disk space is an expensive OS
operation.
You are just as likely to get poor fragmentation growing in 10MB
increments as in 8KB increments.
Sean