You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Heidi Dehaes <in...@gmail.com> on 2008/07/02 10:47:08 UTC
ofbiz is so slow
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
Re: Promotions by Store Group
Posted by David E Jones <jo...@hotwaxmedia.com>.
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.
>
>
Promotions by Store Group
Posted by Rajeev Gupta <ra...@hytechpro.com>.
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.
Re: ofbiz is so slow
Posted by Heidi Dehaes <in...@gmail.com>.
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 <le...@gmail.com>:
> Sorry if this is an obvious question but how much memory have you given to
> OFBiz?
>
> Regards
> Scott
>
> 2008/7/2 Heidi Dehaes <in...@gmail.com>:
>
> > 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 <ja...@les7arts.com>:
> > > 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" <in...@gmail.com>
> > >
> > > > 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
> > > >
> > > >
> > >
> > >
> >
>
Re: ofbiz is so slow
Posted by Scott Gray <le...@gmail.com>.
Sorry if this is an obvious question but how much memory have you given to
OFBiz?
Regards
Scott
2008/7/2 Heidi Dehaes <in...@gmail.com>:
> 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 <ja...@les7arts.com>:
> > 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" <in...@gmail.com>
> >
> > > 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
> > >
> > >
> >
> >
>
Re: ofbiz is so slow
Posted by Jacques Le Roux <ja...@les7arts.com>.
From: "Heidi Dehaes" <in...@gmail.com>
> 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 <ja...@les7arts.com>:
>> 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" <in...@gmail.com>
>>
>> > 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
>> >
>> >
>>
>>
>
Re: ofbiz is so slow
Posted by Heidi Dehaes <in...@gmail.com>.
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 <ja...@les7arts.com>:
> 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" <in...@gmail.com>
>
> > 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
> >
> >
>
>
Re: ofbiz is so slow
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <in...@gmail.com>
> 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
>
Re: ofbiz is so slow
Posted by BJ Freeman <bj...@free-man.net>.
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
>
>
>
Re: ofbiz is so slow
Posted by David E Jones <jo...@hotwaxmedia.com>.
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 <jo...@hotwaxmedia.com>:
>>
>> 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
>>>
>>
>>
Re: ofbiz is so slow
Posted by Heidi Dehaes <in...@gmail.com>.
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 <jo...@hotwaxmedia.com>:
>
> 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
> >
>
>
Re: ofbiz is so slow
Posted by David E Jones <jo...@hotwaxmedia.com>.
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