On Sat, Aug 16, 2008 at 10:55 PM, Andi Voss <andi@...> wrote:

> we are running an ERP-System which is using Firebird v1.5.2.4731
> Sometimes the ERP-system (and only the ERP-system) is so slow, that if
> you want to jump to the next dataset, you'll have to wait >5 sec.
> Sometimes an invoice is created and this takes about 10 - 20 sec.
> I think here are a lot of triggers involved.
> These problems are only sometimes a day and there is no pattern
> identifiable at what time or action it occurs.

> Database header page information:
> Variable header data:
> Sweep interval: 20000
> *END*

Another possibility is that Automatic Sweep is slowing your server.
You don't know when it will fire. And when it fires it slows down your
server.
Try to disable automatic sweep and manually schedule it to run at night.

To disable:
gfix -housekeeping 0 <you db here>

To run manually:
gfix -sweep <your db here>

hth,
--
Douglas Tosi
www.sinatica.com