apache server caching and ofbiz

[Toddnick]

Has anyone used apache's built-in memory based cache with ofbiz? We are
having trouble getting acceptable performance out of ofbiz in terms of page
load times even with cache.properties configured properly. We are still
seeing load times of 5-15 seconds for catalog browsing.
Many thanks
Todd

--
Todd Burdeinei
Web Developer
Burdeinei Corp
702-259-3273 office / fax number
702-372-9920 cell
[hidden email]

[David E. Jones-2]

Have you done profiling to see what is using up all of this time?

It would be better to fix your dynamic pages so that they run faster  
than try to cache the results, which gets quite messy for personalized  
web sites (unless you've remove everything from the pages that is  
driven by the user logged in or other session information).

Chances are you have pages written that are doing a lot of non-cached  
database queries, but there could be other things that are running  
very slow. Using simple practices (like cached database queries where  
appropriate) you should be able to 20-40 catalog browsing pages per  
second on a low-mid range commodity server.

-David


On Jun 22, 2009, at 8:17 AM, Todd Burdeinei wrote:

> Has anyone used apache's built-in memory based cache with ofbiz? We  
> are
> having trouble getting acceptable performance out of ofbiz in terms  
> of page
> load times even with cache.properties configured properly. We are  
> still
> seeing load times of 5-15 seconds for catalog browsing.
> Many thanks
> Todd
>
> --
> Todd Burdeinei
> Web Developer
> Burdeinei Corp
> 702-259-3273 office / fax number
> 702-372-9920 cell
> [hidden email]

[Toddnick]

Thank you David,
Yes- we have removed everything personalized from the pages except the users
profile page.
I'm not sure what you mean by cached db queries, I thought all cache
configurations went through cache.properties? Is that something that is set
at the application level?
 is that something that uses soft ref or file store? What do those refer to?

Thanks again
Todd

On Mon, Jun 22, 2009 at 7:44 AM, David E Jones <[hidden email]> wrote:

>
> Have you done profiling to see what is using up all of this time?
>
> It would be better to fix your dynamic pages so that they run faster than
> try to cache the results, which gets quite messy for personalized web sites
> (unless you've remove everything from the pages that is driven by the user
> logged in or other session information).
>
> Chances are you have pages written that are doing a lot of non-cached
> database queries, but there could be other things that are running very
> slow. Using simple practices (like cached database queries where
> appropriate) you should be able to 20-40 catalog browsing pages per second
> on a low-mid range commodity server.
>
> -David
>
>
>
> On Jun 22, 2009, at 8:17 AM, Todd Burdeinei wrote:
>
>  Has anyone used apache's built-in memory based cache with ofbiz? We are
>> having trouble getting acceptable performance out of ofbiz in terms of
>> page
>> load times even with cache.properties configured properly. We are still
>> seeing load times of 5-15 seconds for catalog browsing.
>> Many thanks
>> Todd
>>
>> --
>> Todd Burdeinei
>> Web Developer
>> Burdeinei Corp
>> 702-259-3273 office / fax number
>> 702-372-9920 cell
>> [hidden email]
>>
>
>

--
Todd Burdeinei
Web Developer
Burdeinei Corp
702-259-3273 office / fax number
702-372-9920 cell
[hidden email]

[David E. Jones-2]

Database caching is an optional feature in the entity engine. Not all  
database data should be cached, or in other words many entities  
contain data that would not be helpful to cache because it would cause  
more problems than it would help in performance.

To see if caching is used or not for the pages in question you'll have  
to look at the code that drives those pages including the data  
preparation scripts, templates, screen definitions, and so on.

Reviewing the code in this way is kind of like doing a liked  
performance review, and you should really consider running your  
customized version of OFBiz under a profiling tool in order to see  
what is really taking all the time.

-David


On Jun 22, 2009, at 9:35 AM, Todd Burdeinei wrote:

> Thank you David,
> Yes- we have removed everything personalized from the pages except  
> the users
> profile page.
> I'm not sure what you mean by cached db queries, I thought all cache
> configurations went through cache.properties? Is that something that  
> is set
> at the application level?
> is that something that uses soft ref or file store? What do those  
> refer to?
>
> Thanks again
> Todd
>
> On Mon, Jun 22, 2009 at 7:44 AM, David E Jones <[hidden email]> wrote:
>
>>
>> Have you done profiling to see what is using up all of this time?
>>
>> It would be better to fix your dynamic pages so that they run  
>> faster than
>> try to cache the results, which gets quite messy for personalized  
>> web sites
>> (unless you've remove everything from the pages that is driven by  
>> the user
>> logged in or other session information).
>>
>> Chances are you have pages written that are doing a lot of non-cached
>> database queries, but there could be other things that are running  
>> very
>> slow. Using simple practices (like cached database queries where
>> appropriate) you should be able to 20-40 catalog browsing pages per  
>> second
>> on a low-mid range commodity server.
>>
>> -David
>>
>>
>>
>> On Jun 22, 2009, at 8:17 AM, Todd Burdeinei wrote:
>>
>> Has anyone used apache's built-in memory based cache with ofbiz? We  
>> are
>>> having trouble getting acceptable performance out of ofbiz in  
>>> terms of
>>> page
>>> load times even with cache.properties configured properly. We are  
>>> still
>>> seeing load times of 5-15 seconds for catalog browsing.
>>> Many thanks
>>> Todd
>>>
>>> --
>>> Todd Burdeinei
>>> Web Developer
>>> Burdeinei Corp
>>> 702-259-3273 office / fax number
>>> 702-372-9920 cell
>>> [hidden email]
>>>
>>
>>
>
>
> --
> Todd Burdeinei
> Web Developer
> Burdeinei Corp
> 702-259-3273 office / fax number
> 702-372-9920 cell
> [hidden email]

[Kumaraswamy nandipati]

Todd Burdeinei.,
If you want to enable apache level cache, you need to enable mod_cache
module.

please go thru the link: http://httpd.apache.org/docs/2.2/mod/mod_cache.html

On Mon, Jun 22, 2009 at 9:16 PM, David E Jones <[hidden email]> wrote:

>
> Database caching is an optional feature in the entity engine. Not all
> database data should be cached, or in other words many entities contain data
> that would not be helpful to cache because it would cause more problems than
> it would help in performance.
>
> To see if caching is used or not for the pages in question you'll have to
> look at the code that drives those pages including the data preparation
> scripts, templates, screen definitions, and so on.
>
> Reviewing the code in this way is kind of like doing a liked performance
> review, and you should really consider running your customized version of
> OFBiz under a profiling tool in order to see what is really taking all the
> time.
>
> -David
>
>
>
> On Jun 22, 2009, at 9:35 AM, Todd Burdeinei wrote:
>
>  Thank you David,
>> Yes- we have removed everything personalized from the pages except the
>> users
>> profile page.
>> I'm not sure what you mean by cached db queries, I thought all cache
>> configurations went through cache.properties? Is that something that is
>> set
>> at the application level?
>> is that something that uses soft ref or file store? What do those refer
>> to?
>>
>> Thanks again
>> Todd
>>
>> On Mon, Jun 22, 2009 at 7:44 AM, David E Jones <[hidden email]> wrote:
>>
>>
>>> Have you done profiling to see what is using up all of this time?
>>>
>>> It would be better to fix your dynamic pages so that they run faster than
>>> try to cache the results, which gets quite messy for personalized web
>>> sites
>>> (unless you've remove everything from the pages that is driven by the
>>> user
>>> logged in or other session information).
>>>
>>> Chances are you have pages written that are doing a lot of non-cached
>>> database queries, but there could be other things that are running very
>>> slow. Using simple practices (like cached database queries where
>>> appropriate) you should be able to 20-40 catalog browsing pages per
>>> second
>>> on a low-mid range commodity server.
>>>
>>> -David
>>>
>>>
>>>
>>> On Jun 22, 2009, at 8:17 AM, Todd Burdeinei wrote:
>>>
>>> Has anyone used apache's built-in memory based cache with ofbiz? We are
>>>
>>>> having trouble getting acceptable performance out of ofbiz in terms of
>>>> page
>>>> load times even with cache.properties configured properly. We are still
>>>> seeing load times of 5-15 seconds for catalog browsing.
>>>> Many thanks
>>>> Todd
>>>>
>>>> --
>>>> Todd Burdeinei
>>>> Web Developer
>>>> Burdeinei Corp
>>>> 702-259-3273 office / fax number
>>>> 702-372-9920 cell
>>>> [hidden email]
>>>>
>>>>
>>>
>>>
>>
>> --
>> Todd Burdeinei
>> Web Developer
>> Burdeinei Corp
>> 702-259-3273 office / fax number
>> 702-372-9920 cell
>> [hidden email]
>>
>
>

--
Thanks,
Kumaraswamy.N
91-9866805250.