Database Timeout expired problem.
-
Hi All, I am working in Web Development Firm. We have client name MSN India. When ever anyone open in.msn.com page from all over the world three banners are loading on the every page. Some of them are serving from our Richmedia server. Msn tracking how many times our banner runs on MSN Portal and we also the same thing. But the report is showing different no. Normally when any banner(Flash) running on msn it is calling our one page name getbase.aspx we are simply inserting into one temporary table. After some specific interval we are running job which will check the detail and find the location and update or insert into the master table from where we are generating reports. Our DB Admin is telling our DB server has capacity to open 42k connection / 1Sec. And when any one banner is running on high priority then it will send 150 to 200 request / 1sec. Then also we are not getting same reports due to timeout expired. Is there any other possible way to reduce the load on db server? So we can stop timeout? It’s very urgent. If any sample code can you put it will be acceptable. <a href="http://www.tardak.com">http://www.tardak.com</a>