Very complex data operation leads to HTTP timeout and does not complete..
Posted on 2008-10-04
Hi I am using VB.net 2003 asp.net 1.1 doing web application on dedicated Windows 2003 server.
One thing in admin web app does very complex thing...
First gets list of all people in database and then needs to update them one at a time. One field needs to be updated in every persons row - it is a point count and depending on how they answered a questionairre they get points added to their account. So i have SP that selects all customers, then it checks them one by one and awards points...
The problem is that the web page times out HTTP timout does not finish.
I also have same exact problem when I pull list of all customers to send out email blast.
It gets all customers and compares them agains do not email list. And then emails the person if not on the do not email list. Problem is there are 100,000 people and it times out and does not email everyone.
Using MS Sql 2005
VB.net 2003 asp.net
(calling sql sp's)
How can I make it not to time out?