Re: Slow Commit

From: Dag Arne Matre <dam_at_robin.no.antispam>
Date: Fri, 30 May 2003 13:53:20 +0200
Message-ID: <4DHBa.16800$8g5.282300@news2.e.nsc.no>

>
> Of interest ... of the lines taking more than 1% of the total time for
> each run is the following:
>
> COMMIT;
>
> recorded as 3.5697 seconds. And this is on a system with no more than a
> few hundred users and what I would consider a low-to-moderate
> transaction rate.
>

A shot in the dark: DEFERRED CONSTRAINTS, maybe in combination with improper indexing? Received on Fri May 30 2003 - 06:53:20 CDT