Performance of Ofbiz

[hzzg6y]

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,

[rrhati2010]

Hi,

Can you please ellaborate on the performance issues you are facing.
Please share me a report on this to analyse. This will help me suggest some tuning ideas if possible.
Share your server configuration and application server details/parameters too.
Also, r u using any performance monitoring tools or techniques to find out performance issues?..do share the reports too.

In addition, do you have a any benchmarked performance parameters available for an ideal eCommerce site?

Regards,

[Mike Z]

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 <[hidden email]> 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.
>

[hzzg6y]

No, I am using Postgresql not MYSQL.

[Paul Piper]

Well, there certainly are ways to push ofbiz.

Have you taken a look at Syracus? www.syracus.net

[hzzg6y]

Please  can  someone help me with performance tips for Ofbiz. I am really struggling to get to high performance of the ecommerce site.

Rgds,

[hans_bakker]

check my blog i wrote sometime ago....

http://www.antwebsystems.com/control/ViewBlogArticle?contentId=16640

Regards,
Hans

On 05/02/2012 05:16 PM, hzzg6y wrote:
> Please  can  someone help me with performance tips for Ofbiz. I am really
> struggling to get to high performance of the ecommerce site.
>
> Rgds,
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Performance-of-Ofbiz-tp4586418p4602795.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

[Scott Gray-2]

In regards to one part of that post, I wouldn't recommend disabling Visit tracking for ecommerce unless you have some other type of analytics in place.  It can be an invaluable resource for tracking down slow pages and also aid in locating requests are causing errors in the logs.

Regards
Scott

On 2/05/2012, at 10:22 PM, Hans Bakker wrote:

> check my blog i wrote sometime ago....
>
> http://www.antwebsystems.com/control/ViewBlogArticle?contentId=16640
>
> Regards,
> Hans
>
> On 05/02/2012 05:16 PM, hzzg6y wrote:
>> Please  can  someone help me with performance tips for Ofbiz. I am really
>> struggling to get to high performance of the ecommerce site.
>>
>> Rgds,
>>
>> --
>> View this message in context: http://ofbiz.135035.n4.nabble.com/Performance-of-Ofbiz-tp4586418p4602795.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[hzzg6y]

Thanks a lot to Hans & Scott for prompt response.

Scott,

       If we don't disable visit function, do we have  any other choice. Ecommerce site should be working like amazon.com else it is of NO use. We need to make ofbiz with top performance as normal PHP+MYSQL site else we will lose visitors & one day we have shut down the business. Please advice if you have any recommendation.

Secondly, Hans in your article at the bottom you mentioned about FTL. Please can you provide some details on the below recommendation. How can I acheive below.

"We recently found out that retrieving database data inside an ftl is not a good idea, not only bad practice but very slow. Retrieving data should be, as much as possible, only be done in the 'action' part of screens."

One person ( Anil ) informed that " I also tried the one thing where I've render the FTL directly in view map instead of rendering it in screen and it saves my 50 % time. "

Please note that I have 2GB Centos 6 VPS server with postgre & JDK 7  -  $ svn co https://svn.apache.org/repos/asf/ofbiz/trunk ofbiz


Rgds,

[Adrian Crum-3]

This thread illustrates the fundamental problem with most performance
tuning advice - there are no statistics, no metrics, no examples, etc.
In other words, there is no concrete information to base a decision on.

I would recommend hiring a qualified and experienced professional to
evaluate your site.

-Adrian

On 5/2/2012 1:46 PM, hzzg6y wrote:

> Thanks a lot to Hans&  Scott for prompt response.
>
> Scott,
>
>         If we don't disable visit function, do we have  any other choice.
> Ecommerce site should be working like amazon.com else it is of NO use. We
> need to make ofbiz with top performance as normal PHP+MYSQL site else we
> will lose visitors&  one day we have shut down the business. Please advice
> if you have any recommendation.
>
> Secondly, Hans in your article at the bottom you mentioned about FTL. Please
> can you provide some details on the below recommendation. How can I acheive
> below.
>
> "We recently found out that retrieving database data inside an ftl is not a
> good idea, not only bad practice but very slow. Retrieving data should be,
> as much as possible, only be done in the 'action' part of screens."
>
> One person ( Anil ) informed that " I also tried the one thing where I've
> render the FTL directly in view map instead of rendering it in screen and it
> saves my 50 % time. "
>
> Please note that I have 2GB Centos 6 VPS server with postgre&  JDK 7  -  $
> svn co https://svn.apache.org/repos/asf/ofbiz/trunk ofbiz
>
>
> Rgds,
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Performance-of-Ofbiz-tp4586418p4603098.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

[Scott Gray-2]

Exactly, you need to perform (or have on performed on your behalf) analysis of the site.  There are plenty of OFBiz sites out there that perform just fine with nothing much more than correctly configured cache settings.

Regards
Scott

On 3/05/2012, at 1:06 AM, Adrian Crum wrote:

> This thread illustrates the fundamental problem with most performance tuning advice - there are no statistics, no metrics, no examples, etc. In other words, there is no concrete information to base a decision on.
>
> I would recommend hiring a qualified and experienced professional to evaluate your site.
>
> -Adrian
>
> On 5/2/2012 1:46 PM, hzzg6y wrote:
>> Thanks a lot to Hans&  Scott for prompt response.
>>
>> Scott,
>>
>>        If we don't disable visit function, do we have  any other choice.
>> Ecommerce site should be working like amazon.com else it is of NO use. We
>> need to make ofbiz with top performance as normal PHP+MYSQL site else we
>> will lose visitors&  one day we have shut down the business. Please advice
>> if you have any recommendation.
>>
>> Secondly, Hans in your article at the bottom you mentioned about FTL. Please
>> can you provide some details on the below recommendation. How can I acheive
>> below.
>>
>> "We recently found out that retrieving database data inside an ftl is not a
>> good idea, not only bad practice but very slow. Retrieving data should be,
>> as much as possible, only be done in the 'action' part of screens."
>>
>> One person ( Anil ) informed that " I also tried the one thing where I've
>> render the FTL directly in view map instead of rendering it in screen and it
>> saves my 50 % time. "
>>
>> Please note that I have 2GB Centos 6 VPS server with postgre&  JDK 7  -  $
>> svn co https://svn.apache.org/repos/asf/ofbiz/trunk ofbiz
>>
>>
>> Rgds,
>>
>> --
>> View this message in context: http://ofbiz.135035.n4.nabble.com/Performance-of-Ofbiz-tp4586418p4603098.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.

[Mike Z]

Try switching java.  Download java from sun and modify the startup script
to use it.  I place java in /opt, like this:

root@vm-121:/opt# ls -al /opt
lrwxrwxrwx  1 root  root    12 2012-03-04 15:36 java -> jdk1.6.0_31/
drwxr-xr-x 10 root  root  4096 2012-03-04 15:36 jdk1.6.0_31

I then reference it as /opt/java/bin/java.

On Wed, May 2, 2012 at 3:16 AM, hzzg6y <[hidden email]> wrote:

> Please  can  someone help me with performance tips for Ofbiz. I am really
> struggling to get to high performance of the ecommerce site.
>
> Rgds,
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Performance-of-Ofbiz-tp4586418p4602795.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[hzzg6y]

I somehow want to redue the startup time for my ecommerce  site. Below are some threads posted by Cameron - information which I need to know whether it is valid today or not.

1. Logging.
In debug.properties, log only to file and not stdout.
Set logging to WARN for everything.

2. Modules.
a. Remove all modules from hot-deploy and specialized
except the ones you actually use.  You might also be
able to remove some of the modules in applications but
they do not have a hierarchical dependency, so you can
probably only remove one or two. We only removed the
marketing module, David has been quite clear about
this in previous posts - its generally more trouble
than its worth.
b. WITHIN the modules, deactivate any webapp you ain't
using (simply comment out the relevant part in
ofbiz-component.xml).  For example, the only module we
left up, apart from our own custom module, was
webtools.

3. Containers
a. For a standard webapp system, we found that we can
get by with only the following 5 containers, we
removed everything else:
 component-container
 classloader-container
 naming-container
 catalina-container

b. Inside catalina-container, only activate the
containers you need - very often it is only http,
https or ajp, depending on your setup

4. Memory.
a. Give the JVM at least 384Mb of memory, otherwise it
really has trouble setting everything up.  You can set
this either in startofbiz.bat/sh, or in service.conf
if you are running as a windows service (see my recent
tutorial on wiki).

There are some other points to explore, which for
various reasons I haven't tried yet.

5. Entity Engine
OFBiz does a lot of clever stuff when it starts up to
match XML entity definitions with what is actually in
the DB.  But in a production system you aren't going
to change this very regularly.  So theoretically you
should switch it off, and shave off a couple more
seconds at start up.
In practice, I only managed the following config for
my delegator in entityengine.xml:
            check-on-start="true"
            add-missing-on-start="true"
            check-pks-on-start="false"

I wanted to set all 3 to false, but when I did this,
the JVM went into an endless loop and then bust with
an OutOfMemoryError.  If anyone could shed any light
I'd be grateful.

6. JDK 1.6
I have run my application without any probs on JDK1.6,
 which is supposed to up to a zillion % faster than
1.5 in certain situations according to SUN.  But I
haven't taken any measurements yet, will let you know
when I do.

7. JNDI
From what I have seen of OFBiz internals so far, it
doesn't really use JNDI for much.  So I will
investigate taking out this container as well, as for
my scenario, I am not getting anything from JNDI.





     

[hzzg6y]

Mike,

       Thanks ... You mean that JDK6 is better than JDK7 ( jdk-7u4-linux-x64.rpm ).  Please  clarify that whether I should use the old version of JDK which finely tuned with Ofbiz.

Rgsd

[hzzg6y]

Since We are using Postgresql. Is it the issue with DB. We can fine to switch to MYSQL but performance need to be improved for ecommerce site.

[Mike Z]

Try running pgtune for postgres and set the figures 30-50% (or more) higher.

pgtune -i /etc/postgresql/8.4/main/postgresql.conf

Requires a restart.

Regarding java, yes, use the latest 1.6 java from sun (only).

On Wed, May 2, 2012 at 8:53 AM, hzzg6y <[hidden email]> wrote:

> Since We are using Postgresql. Is it the issue with DB. We can fine to
> switch
> to MYSQL but performance need to be improved for ecommerce site.
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Performance-of-Ofbiz-tp4586418p4603628.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Sanjeev Gupta]

Also try configuring Apache HTTP server as a fronted to Ofbiz server. Although it will add an additional layer in the architecture, it will handle all static and cached content rendering to browser and improve your app server's performance.

That said, please do to keep in mind that a Java bases server can't be tuned to perform like the LAMP stack. both have their own merits and demerits, but when it come to performance in small deployments, Java stack can't match the LAMP stack.

[Deepak Agarwal-2]

Following has benifited me:
1)  -Xms1024M -Xmx2048M -XX:MaxPermSize=1024m    (Increased the PermSize
from 512 to 1024)
2) Increased innodb_lock_wait_timeout from 50 sec to 300 sec in mysql
3) Added following in mysql
     a) table_cache=1000
     b) table_definition_cache=1000
     c) query_cache_type=1
     d) query-cache-size = 20M
     e) query_cache_limit=20M
      f) open_files_limit=4000
4) Modified framework/base/config/cache.properties to use softreferences
5) Modified ofbiz-container.xml connector at 8080 to use GZip for js and
css.
6) Increased the number of threads to 400 for tomcat container
7) Decreased the connection time out to 3 seconds.

Our box has 2 CPU and 8 GB or RAM .


On Wed, May 2, 2012 at 10:23 PM, Sanjeev Gupta <[hidden email]>wrote:

> Also try configuring Apache HTTP server as a fronted to Ofbiz server.
> Although it will add an additional layer in the architecture, it will
> handle
> all static and cached content rendering to browser and improve your app
> server's performance.
>
> That said, please do to keep in mind that a Java bases server can't be
> tuned
> to perform like the LAMP stack. both have their own merits and demerits,
> but
> when it come to performance in small deployments, Java stack can't match
> the
> LAMP stack.
>
> -----
> Rgds
> Sanjeev
> www.sanjeevg.com
> @sanjeevgcom
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Performance-of-Ofbiz-tp4586418p4603804.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
> --
> Thanks,
> Deepak Agarwal,
>
> Paxcel Technologies Pvt Ltd.
> Hartron Complex, Sector 18, Gurgaon, India.
> E-Mail: [hidden email]
> Mobile: [phone]
>
>