--- In firebird-support@yahoogroups.com, Andi Voss <andi@...> wrote:

>
> Hi,
>
> 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.
>
> All over there are not many people using this ERP (max. 4)
> Hardware: Windows SBS2003, Intel 3GHz, 2,5G RAM, 250 Gig, hardware

raid 1.

> When the ERP is slow, the network is running normal, no heavy

aktivities

> and the task manager of the SBS shows also everything clear.
> I think the ERP-system is a delphi program, but I'm not 100% sure about
> this.

Have you checked the performance monitor (Administration Tools ->
Performance). I would be looking at read and write queues for the
disk, as slow queries tend to be waiting for CPU time or disk access.

If that does turn out OK, then is there a possibility that the queries
are running under a WAIT transaction, and so they are waiting to see
if the conflicting transaction commits or rolls-back before returning.

Your database stats look OK from a garbage perspective (and you would
be seeing a maxed out CPU core if it wasn't).

Adam