Out of Memory error in asp while fetching data from sql and display around 1,00,000 records
-
Hi Friends, I have following issue in asp page…can you pls give any idea for this.. In my asp page I am displaying records from db table to asp page in table format that’s all.. but that table will have more than 1,00,000 records.. So at the time while displaying, its displaying some records around 15,000 then showing the following error. Response object error 'ASP 0100 : 8007000e' Out of memory /aiucreditdev/credit/ImportTCMonthReportStatus.asp, line 0 Unable to allocate required memory. Please help. Thanks in advance, Priya.
-
Hi Friends, I have following issue in asp page…can you pls give any idea for this.. In my asp page I am displaying records from db table to asp page in table format that’s all.. but that table will have more than 1,00,000 records.. So at the time while displaying, its displaying some records around 15,000 then showing the following error. Response object error 'ASP 0100 : 8007000e' Out of memory /aiucreditdev/credit/ImportTCMonthReportStatus.asp, line 0 Unable to allocate required memory. Please help. Thanks in advance, Priya.
-
Hi Friends, I have following issue in asp page…can you pls give any idea for this.. In my asp page I am displaying records from db table to asp page in table format that’s all.. but that table will have more than 1,00,000 records.. So at the time while displaying, its displaying some records around 15,000 then showing the following error. Response object error 'ASP 0100 : 8007000e' Out of memory /aiucreditdev/credit/ImportTCMonthReportStatus.asp, line 0 Unable to allocate required memory. Please help. Thanks in advance, Priya.
Why on earth would you want to display this many rows? There is no possible way for any user to reasonably make sense of that much data. What you should do is to return a sensible subset of the data and allow users to either filter or set up paging with some sort of load-on-demand. At most I would display 200 records (cos the user insisted) and page the rest. Even then put some form of filtering in place so that suers can select what they NEED to see.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me