Have you checked to see what SQL hibernate is sending to the db & see whether it makes sense given what really needs to happen on the db? If not--does hibernate offer any hooks into its SQL generation process that you can use to help it make better choices?
-----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Eric Means Sent: Wednesday, February 21, 2007 4:00 PM To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM Subject: Re: [ADVANCED-DOTNET] SQL Timeout You could always consider making publishing a batch process of some sort; the user clicking Publish or Save or whatever adds those nodes the queue, and a separate process (probably a Windows Service or something) actually performs the needed actions. This might be what you meant by "asynchronously"; I'm not sure. But it's a pattern I've used successfully for various things. On 2/21/07, Mark Brackett <[EMAIL PROTECTED]> wrote: > > 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 > openssl> 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(r) http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com > -- Eric Means [EMAIL PROTECTED] http://www.randomtree.org/eric/ =================================== This list is hosted by DevelopMentor(r) http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
