There are just some queries the SQL engine is not real
efficiient at - put it in a procedure in a "for loop"
- you perfomance will improve markedly. We use to use
GDML for such beasts - twas more efficient.

Ray
--- tremi2 <tremi2@...> wrote:

>
> 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
>
>
>
>

__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/