Sebastien/Richard, Is it possible to post your solutions/tricks you come up with once you fix it so we all can benefit from it?
Cheers, Ozan From: Sebastien Ros [mailto:sebastien....@microsoft.com] Sent: 16 November 2011 18:58 To: orchard-discuss@lists.outercurve.org Subject: RE: performance for exceptionally large blogs It seems to be an important problem, might fall into our current Performance work for next release. Taking the discussion offline with you to fix it. Sebastien From: Dan Schlossberg [mailto:danschlossb...@gmail.com]<mailto:[mailto:danschlossb...@gmail.com]> Sent: Wednesday, November 16, 2011 10:56 AM To: orchard-discuss@lists.outercurve.org<mailto:orchard-discuss@lists.outercurve.org> Subject: Re: performance for exceptionally large blogs Hi Richard. Have you tried installing "new relic" to identify bottleneck? It's a great tool and I think you can get a trial but you do have to install it on your server which might no work for production. Sent from my iPhone On Nov 16, 2011, at 5:19 AM, Richard Slater <rich...@richard-slater.co.uk<mailto:rich...@richard-slater.co.uk>> wrote: Hi, I am in the process of building out a site with a sizeable quantity of blog posts, there are 5 blogs the largest containing 10,000 posts, the next largest containing 1,000 posts. To keep this email short I am not going to include all of the technical details, tell me what you need from me and I will provide it. We have encountered two problems when importing the posts: 1) the more posts that we import (via the orchard command line and a bespoke import module) the fewer posts we get to import before the session times out, I have been able to circumvent the nHibernate session time-out by encapsulating the import of each post in a new TransactionScope with TransactionScopeOption.Suppress however I then run into a .NET remoting time-out. 2) we experience a significant slow down of the whole site, but particularly the blogs dashboard which more often than not was timing out, this appears to be the result of currently unused enumeration of all comments in a blog. We have implemented the following to improve performance: * Warmup - improved start-up times * Set Trust to Full - no obvious effect * Added Index for Orchard_Framework_ContentItemVersionRecord column ContentItemRecord_Id - most frequently run queries, small improvement * Added index for Orchard_Indexing_IndexingTaskRecord column ContentItemRecord_Id - frequently run and expensive - no obvious effect to page load times * Set Resource Debug Mode to Disable - no obvious effect to page load times * Installed Cache and Database Caching modules - significant effect although still slow The biggest improvement was disabling Search and Indexing, so I suspect the indexing service is causing the majority of the problem, search and indexing however are required so that is not an acceptable fix. I have time at the end of the week to focus on performance, profiling and optimization if anyone has some specific areas to look at I would be more than pleased to take on suggestions or advice. Many thanks in advance, Richard Slater ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ________________________________ This e-mail and any attached files are intended for the named addressee only. It contains information which may be confidential and legally privileged and also protected by copyright. Unless you are the named addressee (or authorised to receive for the addressee) you may not copy or use it or disclose it to anyone else. If you received it in error please notify the sender immediately and then delete it from your system. Please be advised that the views and opinions expressed in this e-mail may not reflect the views and opinions of The Digital Property Group Limited or any of its subsidiary companies. We make every effort to keep our network free from viruses. However, you do need to check this e-mail and any attachments to it for viruses as we can take no responsibility for any computer virus which may be transferred by way of this e-mail. We reserve the right to monitor all e-mail communications. The Digital Property Group Limited is a Daily Mail and General Trust plc company. Registered Office: Northcliffe House, 2 Derry Street, London, W8 5TT. Registered in England & Wales No: 02290527 VAT no. 243571174 ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
