Please check in FAQ - I recently posted some suggestions about query optimization. Specifically, I think you might want to:
a) Try a partial optimization instead of a full optimization (sounds weird, I know, but if you read my text, it will start to make sense),
b) Divide one large query into several smaller ones.
HTH, Hilmar.
>We have a web app which needs to support up to 100 plus users. We have multiple web sites that all use basically the same code. One of the websites has a table with 2.5 million records about 350mb. There is one summary report which if pre-digested will run very quickly on the web.
>
>Unfortunately there are 11 fields they want to be able to filter on. We have tried to get them to reduce the number of filterable fields but they won't budge on this. The report takes somewhere between 60 and 90 seconds to run. If we can limit them to 2 or 3 fields, I can pre-digest it further and then the speed would be reasonable.
>
>The machine is a dual 550 and currently running west-wind 3.15.
>
>Is there a solution to this problem?
>
>TIA
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)