Subject | Re: Allocate file on winchester |
---|---|
Author | Alexander V.Nevsky |
Post date | 2003-08-30T13:10:22Z |
--- In firebird-support@yahoogroups.com, Szakály Balázs
<szakalyb@f...> wrote:
subsequently even if you'll expand it's size inserting million of
records and then deleting them and performing sweep to force garbage
collection. Each table's records will be placed on pages physically
far from each other after updates, 80% of selects will be joins of
several tables, used indices will be read from another pages etc.
Best regards,
Alexander.
<szakalyb@f...> wrote:
> Is any trick or procedure to create a larger fdb file on winchesterwhen i create the database, or after the create?
> Because when the file grow daily ~1MB with 10K step, then thewinchester will be wery fragmented..., but if i can set the size to
> 1GB on create, then the file remain unfragmented...Balazs, don't care about this. You database never will be read
subsequently even if you'll expand it's size inserting million of
records and then deleting them and performing sweep to force garbage
collection. Each table's records will be placed on pages physically
far from each other after updates, 80% of selects will be joins of
several tables, used indices will be read from another pages etc.
Best regards,
Alexander.