May 21, 2006 at 9:51 am
Sub: My Question falls in the region of asp.net/VB.net and backend SQL 2000 Server
1. I create a Dataset in asp.net/VB.net.
2. Then, I call a stored Procedure (fully functional and working when run through Query Analyser) that returns a result set . The stored procedure takes Closing balances of previous year ending and adds up current year's transactions in to return Op.Bal, In, Out and Cl.Bal. - Itemwise.
It is a data processing that involves about 100,000 records.
3. The problem - When I run this through my application's web page , in Try Catch routine, it gives me an Application Time out has occured.
4. I have ensured that my web page has 100 minutes of timeout as against default 20 min.
5. When, I run this web page from the Server where my SQL Database is, sometimes I get reult in a minute.
6. I do not understand as to what do I need to do to overcome this problem.
7. The Server hardware configuration is Intel SE 7221 Server motherboard, 4GB of DDR2 RAM 2 x 160GB HDD with MS Win 2003 Server O/s, dot net framework 1.1 and SQL 2000 Server running on it.
Kindly help.
Dilip Nagle
May 22, 2006 at 6:14 am
what is the command timeout?
May 24, 2006 at 6:39 am
Dear Grasshopper,
Where Do I set Command Timeout?
Reagrds,
Dilip Nagle
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply