Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.0 and 1.1 Basics
|
ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 25th, 2008, 07:48 AM
Registered User
 
Join Date: May 2007
Posts: 5
Thanks: 0
Thanked 1 Time in 1 Post
Default <httpRuntime executionTimeout="1000" maxRequest

Hi

I am getting error when i am trying to connect to database. Actually i am fetching data from the database having complex calculation in storeprocedure & taking time to fetch data from database around 2-3 minutes.

after around 50 seconds i am getting error:
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. "

I have changed connection time out property, &
 <httpRuntime executionTimeout="1000" maxRequestLength="102400" />
but not able to fetch data.

Please provide any help for this.

Regards

Anil Goyal
 
Old May 21st, 2008, 08:24 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 428
Thanks: 57
Thanked 2 Times in 2 Posts
Default

I am also suddenly getting this error at random. Did you figure out what was causing it? Were you able to fix it?
 
Old May 22nd, 2008, 09:14 AM
Registered User
 
Join Date: May 2007
Posts: 5
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Ron Howerton,

What you have to do is simply fine tune your all the store procedures.
are you calling any functions in your store procedures. if yes then its bad practice. instead of calling the function from SP's simply write them in you sp.

make sure with up to 100 rows none of your store procedure/function/view/cursor/Triggers should take more then 2 sec. if it is then there is some prob. as the number of rows get increasing, it will lead to the same error.

so please fine tune all of your store procedure/function/triggers.

Anil Goyal

Regards

Anil Goyal
The Following User Says Thank You to anil.goyal For This Useful Post:
Ron Howerton (February 22nd, 2013)
 
Old May 27th, 2008, 01:48 AM
Authorized User
 
Join Date: Sep 2006
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Why not try changing the connection time out property of command object

Check It out
 
Old May 27th, 2008, 10:58 AM
Registered User
 
Join Date: May 2007
Posts: 5
Thanks: 0
Thanked 1 Time in 1 Post
Default

hi Virendar

I changed the connection time out property of command object (upto 660) , but due to some reasons it was taking default timeout. Reason I was not able to find out then i fine tuned all my Stroeprocedures & get rid of the error.


Regards

Anil Goyal





Similar Threads
Thread Thread Starter Forum Replies Last Post
fecthing rows between 1 to 1000 to datatble. tusharkale C# 2 August 9th, 2008 02:35 AM
HttpRuntime vs HttpContext r_adarsh .NET Framework 1.x 1 February 19th, 2008 10:50 AM
Stored Procedure returns EXPR 1000 EDGiridhar Crystal Reports 1 June 14th, 2007 12:58 PM
active directory: problem with 1000 returns empty C# 2005 0 November 18th, 2005 04:39 AM
Chaper 14 - over $1000 problems ftb_tx BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 November 21st, 2004 09:15 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.