Um.... its just a REALLY LONG QUERY.

Terminating your app does no good because the thread is still in the process of finding all of the records you requested.

It is a left join. No indexes are used.

Jason

jasajona wrote:

> Hello,
>
> I have situation:
>
> select
> ...
> from
> table1
> left join table2 on
> table1.field1 = table2.field1
> join table3 on
> table2.field2 = table3.field1
>
> This query never ends on tables with 80000 records (if I change last
> join to left join query executes in 10s)
> Even if I terminate my application server still utilises 100% cpu
> endlesly. Only way is to restart firebird. I use FBSS1.5.3 WinXP. I
> wrote simplified example of my query if there is possibilitie that
> this can be bug of FB I can write all query.
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.