MArco,

demigheldmarco wrote:

>hello,
>
>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

CREATE {DATABASE | SCHEMA} ’ filespec’
[USER ’ username’ [PASSWORD ’ password’]]
[PAGE_SIZE [=] int]
[LENGTH [=] int [PAGE[S]]]
[DEFAULT CHARACTER SET charset]
[ <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!
>
>Marco
>
>

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
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