Anthony Tanas wrote:

> I've compared the databases to make sure they are the same...that leaves the
> only difference as the data itself! How can I figure out where the problem
> is? :(

You can use FBCopy (or some similar tool) to compare the data as well.

> The problem must be in the data since it is only one location but in case it
> may help here is the simplest of the queries that does not return:
>
> SELECT DISTINCT

...

> GROUP BY

I never had a need to use DISTINCT if I have GROUP BY already in there,
GROUP BY already groups records together. Try to remove DISTINCT from
the query.

BTW, what is the plan for that query?

> A side question - if I kill the client the CPU on the server still runs at
> 100% untill I kill the firebird server. Will the firebird server ever give
> up on the query or will it bog down the server untill firebird is restarted?

AFAIK, it will keep working until it tries to fetch the first record and
then it will cancel it.


--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org