What database are you using? If you're using the the default Derby database, there's your problem.
If you're on Postgres, make sure you tune it. http://pgtune.leopard.in.ua/ Also if you're on Postgres make sure you're running a VACUUM at least weekly. Out of the box Postgres is set pretty conservative so it can run well on small VMs. If you're hosting the site in a generic virtual machine or AWS EC2 be aware that the IO performance on these systems is pretty lousy. Nowadays I'd recommend just using Amazon RDS so you don't have to mess with it. Or just do like most folks and throw more RAM at your system and see if that helps. :) --P > On May 18, 2017, at 4:37 AM, Giulio Speri - MpStyle Srl > <[email protected]> wrote: > > Hello everyone, > > I would like to ask you some suggestion on improving performances of our > eCommerce site > We're monitoring our jvm with NewRelic tool and response times are quite > good, and the server on which ofbiz run has minimal cpu/ram usage, but > customers often complains slowness in page loading. > > Which components of OFBiz should we change or on which other aspects should > we work on to get better performances (eg: database, catalina servlet > container, Tomcat..) ? > > Thank you in advance, > > Giulio > > > > -- > Giulio Speri > > *Mp Styl**e Srl* > via Antonio Meucci, 37 > 41019 Limidi di Soliera (MO) > T 059/684916 > M 334/3779851 > > www.mpstyle.it
