> This is the database stats
>
> Database header page information:
>
> Flags 0
> Checksum 12345
> Generation 62059688
> Page size 4096
> ODS version 10.1
> Oldest transaction 62059559
> Oldest active 62059560
> Oldest snapshot 62059560
> Next transaction 62059562
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 0
> Implementation ID 16
> Shadow count 1
> Page buffers 0
> Next header page 0
> Database dialect 1
> Creation date Sep 24, 2005 13:26:48
> Attributes force write
>
> Variable header data:
> Sweep interval: 20000
> *END*
>
> This is for information, but the same database in two
> machines with windows 2003 server, one with AMD Opteron
> processor, and the other one with Pentium 4 Processor, give
> differents level of performance. With the AMD Opteron, it
> last 8 hours and with the Pentium 4 it last 1 hour and a
> half. Both of them with firebird 2.0.3 SuperServer 32 bit
> (there is no 64 bit version). I think may be is something
> with the dual-core.

There are a couple of things that I find interesting:

Shadow count 1

This means that you have a database shadow defined... you should drop
it.

Sweep interval: 20000

I would set the Sweep Interval to 0 -- see GFIX.

Page size 4096

I would backup and restore the database with a page size of 8 or 16KB.


Sean