| Subject | Re: [firebird-support] Re: Slooooow Query ... how to do it better? |
|---|---|
| Author | Radu Sky |
| Post date | 2006-02-17T22:59:04Z |
Do not use summary views with GROUP BY with joining queries.
I had the same problem and used subqueries instead of joining the sum
from the view. I managed to reduce a query from 14 min to under 2 sec
with this.
AFAIK, this problem has been solved for FB2 (please, somebody correct me
if I'm wrong)
HTH
Radu
I had the same problem and used subqueries instead of joining the sum
from the view. I managed to reduce a query from 14 min to under 2 sec
with this.
AFAIK, this problem has been solved for FB2 (please, somebody correct me
if I'm wrong)
HTH
Radu