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 <[email protected]> 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
[email protected]
--
Todd Burdeinei
Web Developer
Burdeinei Corp
702-259-3273 office / fax number
702-372-9920 cell
[email protected]
