Author: ghassan_rashed | Posted on: 5/21/2009 3:32:56 AM | Views : 267

hello all,
 
i develop an application that do the following
i have a table contains the 100000 record.
every month i get 40000-60000 record .. some of these records are new and othe that in my DB
i will check if the record in my database i will do some something in some tables
if that new i will do other actions
 
no problem here ....
 
the problem is :
this proccess will take 1-3 hours (i did it from ASP.Net Pages and try From SQL as a cursor), will take a long time ... inner SQL Less than Asp.net pages
 
after some times (20 minutes ) the page will be can not find this page
how can i solve this problem ?????????
...

Go to the complete details ...