Subject Re: [firebird-support] initial database filesize / avoiding database file fragmentation
Author Alexandre Benson Smith

demigheldmarco wrote:

>I have the following situation:
>- Windows 2003 Server and NTFS
>- Firebird 1.5.2 SuperServer Installation
>- database size: > 3 GB
>- page size: 4096 (default)
>- buffers: 32786
Bad, VERY Bad !!!!

Don use more than 10000 page buffers on FB 1.5.x and earlier, FB 2.0 has
a much improoved algorithm to handle a large number of page buffers, FB
1.5.x tends to slow down with a big cache size.

>Now what I ask for is any good idea to avoid this fragmentation. I
>thougth about two possibilities:
>1. Running the database file on its own harddisk/partition: problem
>on existing systems.
>2. Preallocation of diskspace at database creation time to avoid
>slowly fragmented growing of the database file. But I foud no
>function/parameter to do this.
Check the "create database" statement on IB 6.0 LangRef.pdf to see the
full description, the parts that you are after are

[USER ’ username’ [PASSWORD ’ password’]]
[PAGE_SIZE [=] int]
[LENGTH [=] int [PAGE[S]]]
[ <secondary_file>];
<secondary_file> = FILE ’ filespec’ [ <fileinfo>] [ <secondary_file>]
<fileinfo> = [LENGTH [=] int [PAGE[S]] | STARTING [AT [PAGE]] int }
[ <fileinfo>]

LENGTH [=] int [PAGE[S]]
Specifies the length of a primary or secondary database file. Use for
primary file only if defining a secondary file in the same statement.

>Thanks for help!
see you !


Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.4/66 - Release Date: 09/08/2005