Export to CSV takes too long and times out
634676Mar 12 2010 — edited Mar 18 2010I have a dataset I need to export into excel. The dataset contains about 15 columns, and 250,000 rows. I can display it on the html page by limiting the rows displayed at one time, however, the goal for this data is to be exported into excel.
Unfortunately when I put an export to csv link on and try to export the data the page times out returning a "No Response from Application Web Server" error before the save dialog box even appears.
Is there a workaround that will avoid the time out, possibly prompt the save as box to appear before the query parses all of the data for the file? Is there any other way to export this data to excel without the timeout issue?
Thank you in advance,
Adam