| Subject | Firebird seems to be in cycle |
|---|---|
| Author | tremi2 |
| Post date | 2005-03-04T14:43:13Z |
After this query type the firebird engine seems to be in cycle.
delete pr_lekrvzp t where exists (select 1 from pr_lekrvzp where
t.n_part=n_part having count(*)>1 and t.poradi<>max(poradi))
Utilization CPU on linux is about 99.5 %, mem usage <10 %. When I
abnormally stop the client (console) utilization gets down to 0%.
I have tried some other queries and when I have used EXISTS , IN or
subquery always this ends similarly.
Can you help me?
Milos
delete pr_lekrvzp t where exists (select 1 from pr_lekrvzp where
t.n_part=n_part having count(*)>1 and t.poradi<>max(poradi))
Utilization CPU on linux is about 99.5 %, mem usage <10 %. When I
abnormally stop the client (console) utilization gets down to 0%.
I have tried some other queries and when I have used EXISTS , IN or
subquery always this ends similarly.
Can you help me?
Milos