Aug 13, 2014 at 9:11 PM
Edited Aug 14, 2014 at 4:28 PM
I did some stress testing(using jmeter) and got these results:
So, here's an example of getting a list of content used on the site.
_contentManager.GetMany<part>("list of ids", VersionOptions.Published, QueryHints.Empty).ToList();
The errors I received:
Orchard/ContentManagement/DefaultContentMangager.cs Line: 359
An exception of type 'System.InvalidOperationException' occurred in NHibernate.SqlAzure.dll but was not handled in user code. There is already an open DataReader associated with this Command which must be closed first.
Also got the error on line 243
private ContentItemVersionRecord GetVersionRecord(VersionOptions options, ContentItemRecord itemRecord)
I also found that the error originated when I called
So everything seems to work fine locally but when put under stress it breaks.
Note: Orchard is is up to date.
I noticed that when I query my tables for information that are not connected to Orchard parts I don't get errors but when contentManager gets multiple requests to get a part it starts to break and cause a 404 error.
If anyone has used contentManager to get a part and tested it under heavy load it would be cool if you posted an example of your code. Also, ways to go around content manager to get parts if it's possible would be helpful.