I've been having headache for 3 days on this problem of retrieving 65,000 rows of DataTable from Oracle database. Customer needs to download the entire bill data. I tried a couple of ways of getting data, by filling DataSet or executing a DataReader, and generate a .csv file and zip it up on the server for download. But it either takes too long or gives an error of "Page Cannot be displayed". I'm not even doing any data binding to any control. Just the retrieving data seems to take forever. What is a good approach to this issue? Anybody can advise?
Yubo

I would suggest using a stored procedure. And check the timout parameter on your page or in the web.config file.

If the problem is not the database response time (your other topic indicated that the Oracle database was responding to this query ok) then the problem is most likely the amount of HTML. 65000 rows would certainly result in a whole lot of HTML. If you really need all that data together about all you can do to streamline the HTML as much as possible. Instead of a datagrid, use a repeater control. This will allow you to control the output HTML of the repeated items.

-Peter

you have 65,000 rows but in your page you just show limited rows,so in my opinion,you can use paging technique in your grid and every time just fetch limited rows from DB and bind them to your grid (its example).

_____________________________
Mehdi.
software engineering student.
Looking for a good job for summer 2005.

can you explain it?how can I do that?did you mean compressing something like this, http://www.codeproject.com/aspnet/WhitespaceFilter.asp