Major Performance issues with a classifieds build...Help?? Anyone..

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
9/4/2011 9:34:29 PM
Gravatar
Total Posts 28

Major Performance issues with a classifieds build...Help?? Anyone..

Hi all, Have got a classifieds network that we have built out with 7 child sites. (im not a developer btw) 

On the search pages of the classifieds sites, when a user runs a search there seems to be loads of round trips to the DB which is in the thousands per a search. This is loading up the dedicated servers cpu resources from SQL server.

I employed another developer (whom does not know much about mojo) to have a look at the search to try and find out why everything is so slow and he has told me that because we have used mojo cms for the classifieds site for each visit the portal queries the DB to build that form from metadata.

He has suggested that we rebuild the search function without the cms framework as a standalone asp.net form. He has also suggested that mojo should have some sort of caching so the redundant DB round trips can be eliminated.

Can anyone make any suggestions with these issues? Or is a simple case of over a year of work down the drain? The parent site is cars  4   sale  australia dot com au .

 

 

9/5/2011 6:25:00 AM
Gravatar
Total Posts 18439

Re: Major Performance issues with a classifieds build...Help?? Anyone..

You are using a custom feature not something included in mojoPortal so if you are having performance problems with this custom feature you should ask the developer who built it about the problem instead of assuming it is caused by mojoPortal (which it is not).

The mojoPortal internal search does not even use the database (it is based on Lucene.NET search engine and it uses a file based search index that is very fast) and it looks to me like you are not even using it but instead using some custom search implemented by someone else and more than likely your custom search is using the database but that is not part of mojoPortal. mojoPortal has no control over your custom features and how well they perform. If your custom feature does expensive hits to the database there is nothing mojoPortal can magically do to make it work well. If you need to cache results from your own hits to the database then cache them in your custom code.

Someone built all that custom functionality, if not you and not your current developer I suggest get in contact with the developer who did the work, it is not part of mojoPortal and mojoPortal is not to blame for the problems you are having with your custom code.

 

9/5/2011 7:25:38 AM
Gravatar
Total Posts 28

Re: Major Performance issues with a classifieds build...Help?? Anyone..

Hi Joe, wasnt seeking to blame the mojo platform, is great as far as im concerned..Ok so its actually the custom module and has nothing to do with how it has been implemented into mojo. Hey im not a developer... Am actually seeking advice how to handle this..

9/5/2011 7:37:49 AM
Gravatar
Total Posts 18439

Re: Major Performance issues with a classifieds build...Help?? Anyone..

Hi Greg,

Ok, no offense taken or anything, just clarifying it since your new developer seems to think it has something to do with mojoPortal.

My advice is contact the developer who implemented the custom functionality, he should be the best resource to diagnose and fix the problems with it since he knows how it was implemented and how it works he should also know where the likely bottlenecks are. The solution could be to add caching or it could be something as simple as adding some indexes to the database to improve the query performance or tuning the queries to make them more efficient.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.