First thing to check is if mysql is properly tuned. With the huge number of tables, it is important that the table cache is large. Try running tuning-primer.sh on the DB host and make changes as recommended.
https://launchpad.net/mysql-tuning-primer On Wed, Apr 25, 2012 at 5:26 AM, hzzg6y <rupadh...@gmail.com> wrote: > Dear All, > > I have just started using the Ofbiz for my ecommerce website. > However I am seeing a huge performance problems with ofbiz. My website is > quite slow compared to many other websites on ecommerce. I have modified > cache Settings ( cache.properties) & debug properties ( debug.properties > ), > however I still see that Widgets take lot of time to load. Earlier I have > experience with MYSQL + PHP + SMARTY template engine. In this case whenever > I type the website URL, websiite immediately opens however here at ofbiz it > is taking a while to open the front page. This will impact visitors on my > website. > Please can someone advice me on any best Frontend GUI which works with > OFbiz > with super performance. Sorry I don't have benchmark or data to prove this > however it is by visual inspection for last one month. > > I am using trunk : $ svn co http://svn.apache.org/repos/asf/ofbiz/trunk > ofbiz > > Rgs, > > > > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Performance-of-Ofbiz-tp4586418p4586418.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
