We have a web app with a classic asp front end and SQL Server backend. One particular table has many records. Our app allows users to search against that table creating "reports" that are either spit to the browser or sent to excel. These reports pull data from that table, plus some others.
The problem is, the time it takes sometimes has the server time-out. I know I can change some of these timeout variables on IIS, code, etc, but it really takes a while to process this report.
Is there a better way rather than a straight query and display?