| Subject | Re: [firebird-support] extremely slow ( delete trigger procedure ) |
|---|---|
| Author | Aage Johansen |
| Post date | 2004-08-09T21:48:18Z |
Metin Gönen wrote:
You could show the table and index definitions, and the statistics for the
indexes (your own and system created ones for the POSHAR) - maybe someone
can help.
Are the deletes slow if you disable the trigger?
Is there a PK involved here somewhere?
How many records get updated?
--
Aage J.
>A shot in the dark ...
>
> Hi , this is the second time I post this message to the group. If someone
> can answer me I will be very happy.
>
> ...
>
You could show the table and index definitions, and the statistics for the
indexes (your own and system created ones for the POSHAR) - maybe someone
can help.
Are the deletes slow if you disable the trigger?
Is there a PK involved here somewhere?
How many records get updated?
--
Aage J.