ofbiz is so slow

[Heidi Dehaes - Olagos]

Hello,

I use the ofbiz application and embedded tomcat server behind a Apache
webserver.
I am wondering that webpages on the Apache web server are very fast
and webpages from the ofbizapplication are very slow.

My database behind the application is MYSQL.
I use 4 GB central memory with a Q6600 Quad Core Intel Processor on
Windows Vista.

Is it normal ? How to speed up the ofbiz application?
I use already standard caching possibilities in the catalog screen.

Regards,
Heidi

ofbiz:       http://www.olagos.eu
apache:   http://www.olagos.eu/soldenzomer2008/index.html

[David E Jones]

I guess it depends on what you mean by "slow". Compared to static  
pages serving up dynamic pages rendered on the fly will definitely be  
slower, but on a machine like that you should still be able to get  
50-100 pages per second.

Have you gone through the Technical Production Setup Guide and done  
the performance related configurations (especially of the caching)?

-David


On Jul 2, 2008, at 2:47 AM, Heidi Dehaes wrote:

> Hello,
>
> I use the ofbiz application and embedded tomcat server behind a Apache
> webserver.
> I am wondering that webpages on the Apache web server are very fast
> and webpages from the ofbizapplication are very slow.
>
> My database behind the application is MYSQL.
> I use 4 GB central memory with a Q6600 Quad Core Intel Processor on
> Windows Vista.
>
> Is it normal ? How to speed up the ofbiz application?
> I use already standard caching possibilities in the catalog screen.
>
> Regards,
> Heidi
>
> ofbiz:       http://www.olagos.eu
> apache:   http://www.olagos.eu/soldenzomer2008/index.html

[Heidi Dehaes - Olagos]

If you try my pages you will see i have only 1 page in 5 seconds, i guess.

No i didn't tune the caching. It is rather difficult stuff for me.

Heidi

2008/7/2, David E Jones <[hidden email]>:

>
> I guess it depends on what you mean by "slow". Compared to static pages
> serving up dynamic pages rendered on the fly will definitely be slower, but
> on a machine like that you should still be able to get 50-100 pages per
> second.
>
> Have you gone through the Technical Production Setup Guide and done the
> performance related configurations (especially of the caching)?
>
> -David
>
>
>
> On Jul 2, 2008, at 2:47 AM, Heidi Dehaes wrote:
>
> > Hello,
> >
> > I use the ofbiz application and embedded tomcat server behind a Apache
> > webserver.
> > I am wondering that webpages on the Apache web server are very fast
> > and webpages from the ofbizapplication are very slow.
> >
> > My database behind the application is MYSQL.
> > I use 4 GB central memory with a Q6600 Quad Core Intel Processor on
> > Windows Vista.
> >
> > Is it normal ? How to speed up the ofbiz application?
> > I use already standard caching possibilities in the catalog screen.
> >
> > Regards,
> > Heidi
> >
> > ofbiz:       http://www.olagos.eu
> > apache:   http://www.olagos.eu/soldenzomer2008/index.html
> >
>
>

[David E Jones]

Try reading the instructions (in the Technical Production Setup  
Guide), it's really quite simple.

Of course, there are those who do this sort of thing on a regular  
basis for hire if you're not comfortable managing the server yourself.

One page in 5 seconds is really bad (except for pages that wait for  
big background processes). Of course, if you have a bunch of custom  
pages it could be that they were written really poorly and get way too  
much from the database and do it in inefficient way.

Chances are it's just the config/code caching though. Super easy to  
change the cache.properties file for this...

-David


On Jul 2, 2008, at 3:01 AM, Heidi Dehaes wrote:

> If you try my pages you will see i have only 1 page in 5 seconds, i  
> guess.
>
> No i didn't tune the caching. It is rather difficult stuff for me.
>
> Heidi
>
> 2008/7/2, David E Jones <[hidden email]>:
>>
>> I guess it depends on what you mean by "slow". Compared to static  
>> pages
>> serving up dynamic pages rendered on the fly will definitely be  
>> slower, but
>> on a machine like that you should still be able to get 50-100 pages  
>> per
>> second.
>>
>> Have you gone through the Technical Production Setup Guide and done  
>> the
>> performance related configurations (especially of the caching)?
>>
>> -David
>>
>>
>>
>> On Jul 2, 2008, at 2:47 AM, Heidi Dehaes wrote:
>>
>>> Hello,
>>>
>>> I use the ofbiz application and embedded tomcat server behind a  
>>> Apache
>>> webserver.
>>> I am wondering that webpages on the Apache web server are very fast
>>> and webpages from the ofbizapplication are very slow.
>>>
>>> My database behind the application is MYSQL.
>>> I use 4 GB central memory with a Q6600 Quad Core Intel Processor on
>>> Windows Vista.
>>>
>>> Is it normal ? How to speed up the ofbiz application?
>>> I use already standard caching possibilities in the catalog screen.
>>>
>>> Regards,
>>> Heidi
>>>
>>> ofbiz:       http://www.olagos.eu
>>> apache:   http://www.olagos.eu/soldenzomer2008/index.html
>>>
>>
>>

[Jacques Le Roux]

I'm not a specialist, but I will 1st switch from Vista to Linux :o)
I'm quite sure Vista is not really production ready (never tried Vista and I think will never)
But there are plenty all other tricks which are not specific to OFBiz...
You can't compare access to static content behind Apache to dynamic pages from OFBiz.
Are you using a second server for DB at least ? Have you separated your static content and provide it directly from Apache server in
front ? Etc.

Jacques

From: "Heidi Dehaes" <[hidden email]>

> Hello,
>
> I use the ofbiz application and embedded tomcat server behind a Apache
> webserver.
> I am wondering that webpages on the Apache web server are very fast
> and webpages from the ofbizapplication are very slow.
>
> My database behind the application is MYSQL.
> I use 4 GB central memory with a Q6600 Quad Core Intel Processor on
> Windows Vista.
>
> Is it normal ? How to speed up the ofbiz application?
> I use already standard caching possibilities in the catalog screen.
>
> Regards,
> Heidi
>
> ofbiz:       http://www.olagos.eu
> apache:   http://www.olagos.eu/soldenzomer2008/index.html
>

[BJ Freeman]

do a CTRL-ALT-DEL
to get the task manager
take a look at the processes when accessing the pages.
also look at memory allocation, even with 4 gigs is you have a lot of
processes you may be using virtual memory.


Heidi Dehaes sent the following on 7/2/2008 1:47 AM:

> Hello,
>
> I use the ofbiz application and embedded tomcat server behind a Apache
> webserver.
> I am wondering that webpages on the Apache web server are very fast
> and webpages from the ofbizapplication are very slow.
>
> My database behind the application is MYSQL.
> I use 4 GB central memory with a Q6600 Quad Core Intel Processor on
> Windows Vista.
>
> Is it normal ? How to speed up the ofbiz application?
> I use already standard caching possibilities in the catalog screen.
>
> Regards,
> Heidi
>
> ofbiz:       http://www.olagos.eu
> apache:   http://www.olagos.eu/soldenzomer2008/index.html
>
>
>

[Heidi Dehaes - Olagos]

Yes, i know Linux is better but i am not a specialist in Linux.
But i am not using a separate server for the database? I thought my
workstation has enough power and memory to do it on the same machine.
Should it be better to separate the db on a separate machine?
The static content is separated and directly accessible from the Apache server.

Heidi

2008/7/2, Jacques Le Roux <[hidden email]>:

> I'm not a specialist, but I will 1st switch from Vista to Linux :o)
> I'm quite sure Vista is not really production ready (never tried Vista and I
> think will never)
> But there are plenty all other tricks which are not specific to OFBiz...
> You can't compare access to static content behind Apache to dynamic pages
> from OFBiz.
> Are you using a second server for DB at least ? Have you separated your
> static content and provide it directly from Apache server in
> front ? Etc.
>
> Jacques
>
> From: "Heidi Dehaes" <[hidden email]>
>
> > Hello,
> >
> > I use the ofbiz application and embedded tomcat server behind a Apache
> > webserver.
> > I am wondering that webpages on the Apache web server are very fast
> > and webpages from the ofbizapplication are very slow.
> >
> > My database behind the application is MYSQL.
> > I use 4 GB central memory with a Q6600 Quad Core Intel Processor on
> > Windows Vista.
> >
> > Is it normal ? How to speed up the ofbiz application?
> > I use already standard caching possibilities in the catalog screen.
> >
> > Regards,
> > Heidi
> >
> > ofbiz:       http://www.olagos.eu
> > apache:   http://www.olagos.eu/soldenzomer2008/index.html
> >
> >
>
>

[Scott Gray]

Sorry if this is an obvious question but how much memory have you given to
OFBiz?

Regards
Scott

2008/7/2 Heidi Dehaes <[hidden email]>:

> Yes, i know Linux is better but i am not a specialist in Linux.
> But i am not using a separate server for the database? I thought my
> workstation has enough power and memory to do it on the same machine.
> Should it be better to separate the db on a separate machine?
> The static content is separated and directly accessible from the Apache
> server.
>
> Heidi
>
> 2008/7/2, Jacques Le Roux <[hidden email]>:
> > I'm not a specialist, but I will 1st switch from Vista to Linux :o)
> > I'm quite sure Vista is not really production ready (never tried Vista
> and I
> > think will never)
> > But there are plenty all other tricks which are not specific to OFBiz...
> > You can't compare access to static content behind Apache to dynamic pages
> > from OFBiz.
> > Are you using a second server for DB at least ? Have you separated your
> > static content and provide it directly from Apache server in
> > front ? Etc.
> >
> > Jacques
> >
> > From: "Heidi Dehaes" <[hidden email]>
> >
> > > Hello,
> > >
> > > I use the ofbiz application and embedded tomcat server behind a Apache
> > > webserver.
> > > I am wondering that webpages on the Apache web server are very fast
> > > and webpages from the ofbizapplication are very slow.
> > >
> > > My database behind the application is MYSQL.
> > > I use 4 GB central memory with a Q6600 Quad Core Intel Processor on
> > > Windows Vista.
> > >
> > > Is it normal ? How to speed up the ofbiz application?
> > > I use already standard caching possibilities in the catalog screen.
> > >
> > > Regards,
> > > Heidi
> > >
> > > ofbiz:       http://www.olagos.eu
> > > apache:   http://www.olagos.eu/soldenzomer2008/index.html
> > >
> > >
> >
> >
>

[Heidi Dehaes - Olagos]

You mean in the startup command?
I don't know by heart. I am at a distance from my (remote) server now.

What do you propose for a 4 GB central memory? With Vista 32 bit only
3 GB is addressable. And my MYSQL database has to run also.

Heidi

2008/7/2, Scott Gray <[hidden email]>:

> Sorry if this is an obvious question but how much memory have you given to
> OFBiz?
>
> Regards
> Scott
>
> 2008/7/2 Heidi Dehaes <[hidden email]>:
>
> > Yes, i know Linux is better but i am not a specialist in Linux.
> > But i am not using a separate server for the database? I thought my
> > workstation has enough power and memory to do it on the same machine.
> > Should it be better to separate the db on a separate machine?
> > The static content is separated and directly accessible from the Apache
> > server.
> >
> > Heidi
> >
> > 2008/7/2, Jacques Le Roux <[hidden email]>:
> > > I'm not a specialist, but I will 1st switch from Vista to Linux :o)
> > > I'm quite sure Vista is not really production ready (never tried Vista
> > and I
> > > think will never)
> > > But there are plenty all other tricks which are not specific to OFBiz...
> > > You can't compare access to static content behind Apache to dynamic pages
> > > from OFBiz.
> > > Are you using a second server for DB at least ? Have you separated your
> > > static content and provide it directly from Apache server in
> > > front ? Etc.
> > >
> > > Jacques
> > >
> > > From: "Heidi Dehaes" <[hidden email]>
> > >
> > > > Hello,
> > > >
> > > > I use the ofbiz application and embedded tomcat server behind a Apache
> > > > webserver.
> > > > I am wondering that webpages on the Apache web server are very fast
> > > > and webpages from the ofbizapplication are very slow.
> > > >
> > > > My database behind the application is MYSQL.
> > > > I use 4 GB central memory with a Q6600 Quad Core Intel Processor on
> > > > Windows Vista.
> > > >
> > > > Is it normal ? How to speed up the ofbiz application?
> > > > I use already standard caching possibilities in the catalog screen.
> > > >
> > > > Regards,
> > > > Heidi
> > > >
> > > > ofbiz:       http://www.olagos.eu
> > > > apache:   http://www.olagos.eu/soldenzomer2008/index.html
> > > >
> > > >
> > >
> > >
> >
>

[Jacques Le Roux]

From: "Heidi Dehaes" <[hidden email]>
> Yes, i know Linux is better but i am not a specialist in Linux.
> But i am not using a separate server for the database? I thought my
> workstation has enough power and memory to do it on the same machine.
> Should it be better to separate the db on a separate machine?

Yes, definitively

> The static content is separated and directly accessible from the Apache server.

Good !

Jacques

>
> Heidi
>
> 2008/7/2, Jacques Le Roux <[hidden email]>:
>> I'm not a specialist, but I will 1st switch from Vista to Linux :o)
>> I'm quite sure Vista is not really production ready (never tried Vista and I
>> think will never)
>> But there are plenty all other tricks which are not specific to OFBiz...
>> You can't compare access to static content behind Apache to dynamic pages
>> from OFBiz.
>> Are you using a second server for DB at least ? Have you separated your
>> static content and provide it directly from Apache server in
>> front ? Etc.
>>
>> Jacques
>>
>> From: "Heidi Dehaes" <[hidden email]>
>>
>> > Hello,
>> >
>> > I use the ofbiz application and embedded tomcat server behind a Apache
>> > webserver.
>> > I am wondering that webpages on the Apache web server are very fast
>> > and webpages from the ofbizapplication are very slow.
>> >
>> > My database behind the application is MYSQL.
>> > I use 4 GB central memory with a Q6600 Quad Core Intel Processor on
>> > Windows Vista.
>> >
>> > Is it normal ? How to speed up the ofbiz application?
>> > I use already standard caching possibilities in the catalog screen.
>> >
>> > Regards,
>> > Heidi
>> >
>> > ofbiz:       http://www.olagos.eu
>> > apache:   http://www.olagos.eu/soldenzomer2008/index.html
>> >
>> >
>>
>>
>

[Rajeev Gupta-6]

Is there a way to setup promotions by Store Group? We are able to set the
promotions one-store-at a time. What could we do so that we can say that
this promotion will run in all the outlet stores, for example.

Any ideas will be helpful.

[David E Jones]

There is nothing implemented for this right now, but it certainly  
could be done using the existing ProductStoreGroup entity and adding a  
new entity, something like ProductStoreGroupPromo which would be a lot  
like the ProductStorePromo entity.

-David


On Jul 3, 2008, at 10:36 AM, Rajeev Gupta wrote:

> Is there a way to setup promotions by Store Group? We are able to  
> set the
> promotions one-store-at a time. What could we do so that we can say  
> that
> this promotion will run in all the outlet stores, for example.
>
> Any ideas will be helpful.
>
>