You've probably already thought about/tried this - asynchrounous processing so that it processes in the background. You also could probably set it up so that an online user can kick it off and then have an email (with the link to download) sent to them automatically when it completes. ALso, I'm assuming that you're either running COM or multiple instances of File_Based. Running 1 instance of File_Based is a sure way to slow things down...
>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