Problem scaling with DMX_GetCategoryContents

Site
Web

Bring2mind Forums

Forums
Search Forum
Advanced SearchTopicsPosts

Forums > Document Exchange > API

Problem scaling with DMX_GetCategoryContents

Last Post 09/17/2009 1:24 PM by Peter Donker. 3 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

EAS

New Member
Posts:2

09/11/2009 6:47 PM
Hi, We're finding that this one stored procedure - DMX_GetCategoryContents - is executed multiple times for each page load. As a result, it is the consumer of 90% of the resources on the database server and we're unable to scale as much as we'd like to. Is there some configuration we can change to reduce the number of calls to this particular sp? thanks.

Peter Donker

Veteran Member
Posts:4536

09/12/2009 10:38 AM
Hi Beth, We're continuously looking to optimize the code. What you observe is in part a result of working with Ajax where multiple calls are made. There is no tweak you can do at this point (we would have included it ourselves otherwise). We take your observation along with the work for the upcoming version. Peter

EAS

New Member
Posts:2

09/14/2009 9:38 PM
Peter, Thanks for the response. Alot of the database calls use the same parameters over and over. Do you know if DNN caching would help that situation? Thanks again, Beth

Peter Donker

Veteran Member
Posts:4536

09/17/2009 1:24 PM
Hi Beth, We use caching extensively. And I know that SQL caches execution plans itself, so the data retrieval should not take too long. We have to be careful with the DNN caching to avoid exploding the memory consumption of DNN/DMX. If you cache something that changes for every user or every document, for instance, you might end up with massive cache purges making DNN slow. So we only cache a limited set of data that is needed across the application and that remains pretty stable. Note: I'm not excluding it could be an option, just that it needs to be looked at carefully for scalability. Peter

You are not authorized to post a reply.

Forums > Document Exchange > API

About Bring2mind

Bring2mind is the company of Peter Donker, a DotNetNuke enthusiast who has been involved with the platform from the very beginning. At the same time as the market for modules emerged, he realized there was no good document management solution for the platform yet and he set about creating this. In part he based the module on his experience with other document management systems he used while working as a researcher. His module, Document Exchange, was an instant success and has since become the premier document management solution for DotNetNuke. In 2004 he created Bring2mind as a vehicle for the module and is one of the few successful businesses solely based on a DotNetNuke product.

Contact Info

Please note we are located in Europe. Business hours are weekdays between 9 AM and 6 PM local time (Central European Time) which corresponds to 3 AM and noon EST.