Best option is to tune the query or database to get it to run faster. If what you're asking the db to do can't run in under 60 seconds (which I think is the default timeout), then you probably need to reconsider doing it while the user is waiting anyways.
--Mark Brackett -----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Paul Cowan Sent: Wednesday, February 21, 2007 12:29 PM To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM Subject: [ADVANCED-DOTNET] SQL Timeout Hi, I wonder what my design options are for the following problem: 1. We have an ASP.NET application that is a CMS. Part of the functionality is that an update to a section of the page and then consequencely updates all the child nodes and all their child nodes etc. 2. The application uses NHibernate for db interaction. 3. The site has now grown to such an extent that we are getting SqlTimeouts as the process takes an age to complete. My question is what are my options? I can change the timeout but has this a very short term fix. Would calling this functionality asynchronously in anyway help? Cheers [EMAIL PROTECTED] > Date: Tue, 20 Feb 2007 22:42:17 -0600> From: [EMAIL PROTECTED]> Subject: Re: [ADVANCED-DOTNET] importing RSA public/private keys from openssl> To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM> > I took a 2nd look at that link you sent me. I think I may have gotten a good> start on it.> > Thanks again!> > Cheers!> Dave> ----- Original Message -----> From: "dave wanta" <[EMAIL PROTECTED]>> To: <ADVANCED-DOTNET@DISCUSS.DEVELOP.COM>> Sent: Tuesday, February 20, 2007 6:33 PM> Subject: Re: [ADVANCED-DOTNET] importing RSA public/private keys from> openssl> > > > Yeah, I saw that. Unfortunately it's 2.0. I was hoping to find a starting> > point for a 1.1 app. Your right, this is a PITA.> >> > Cheers!> > Dave> > ----- Original Message -----> > From: "Mark Brackett" <[EMAIL PROTECTED]>> > To: =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
