There are a LOT of things that affect performance. Your best bet is
to have someone with experience take a look at it.
At a high level there are a few things to watch out for that seem to
come up often:
1. cache settings and performance statistics
2. server resources, especially memory and looking at paging to/from
the hard to see if you're running out of memory
3. database performance, especially for pages like find party when
you have a lot of parties in the database; for Postgres: have you run
a vacuum since loading a bunch of data, and do you have regularly
scheduled vacuum calls? databases in general need to be optimized,
especially initially, but also periodically for all production
systems; there just isn't any good way around this and it sometimes
involves some manual effort like watching queries for common slow
things that could use some additional indices and such
-David
On Aug 18, 2006, at 8:30 AM, Walter Vaughan wrote:
We have noticed a drastic slowness in building pages that does not
seem to be fixed with following the Production Guide instructions
on setting the caches.
I realize we have a ton more to learn, but I need to start doing
demonstrations of our Data in OFBiz, and I need it to work within
expectations.
We are seeing sometimes as long as 29 seconds to finish drawing a
page.
We are "svn"ed as of yesterday.
For example, clicking on the Catalog draws the left hand side
instantly, but hangs for 10 to 20 seconds sometimes before it
displays the "catalog adminstration main page screenlet".
Another example is clicking on Party. I draws the top half
instantly, and takes as long as 10 to 30 seconds to display the
"parties found" screenlet.
I've included a log that probably isn't interesting till later in
the dump
2006-08-18 14:23:20,017 (TP-Processor8) [ ControlServlet.java:
90 :INFO ] The character encoding of the request is: [null]. The
character encoding we will use for the request and response is:
[UTF-8]
2006-08-18 14:23:20,018 (TP-Processor8) [ ControlServlet.java:
126:DEBUG] [[[main] Servlet Starting, doing setup- total:0.0,since
last(Begin):0.0]]
2006-08-18 14:23:20,019 (TP-Processor8) [ ControlServlet.java:
175:DEBUG] [[[main] Setup done, doing Event(s) and View(s)- total:
0.0,since last([main] Servlet St...):0.0]]
2006-08-18 14:23:20,020 (TP-Processor8) [ RequestHandler.java:
203:INFO ] [Processing Request]: main
2006-08-18 14:23:20,024 (TP-Processor8) [ RequestManager.java:
114:INFO ] [RequestManager.getRequestAttribute] Value for attribute
"null" of uri "main" not found
2006-08-18 14:23:20,025 (TP-Processor8) [ RequestHandler.java:
386:INFO ] [RequestHandler.doRequest]: Response is a view.
2006-08-18 14:23:20,026 (TP-Processor8) [ RequestHandler.java:
538:INFO ] servletName=control, view=main
2006-08-18 14:23:20,027 (TP-Processor8) [ ScreenRenderer.java:
194:INFO ] Found session attribute that conflicts with parameter
name, leaving request parameter in place for name: externalLoginKey
2006-08-18 14:23:20,028 (TP-Processor8) [ PrimaryKeyFinder.java:
132:INFO ] Returning null because found incomplete primary key in
find: [GenericEntity:Product][productId,null()]
2006-08-18 14:23:20,352 (TP-Processor8) [ ServiceDispatcher.java:
450:DEBUG] [[Sync service finished- total:0.0010,since last(Begin):
0.0010]] - 'catalog / getProductCategoryAndLimitedMembers'
2006-08-18 14:23:43,452 (TP-Processor8) [ ControlServlet.java:
250:DEBUG] [[[main] Done rendering page, Servlet Finished- total:
23.433,since last([main] Setup done...):23.433]]
2006-08-18 14:23:47,701 (TP-Processor3) [ ControlServlet.java:
90 :INFO ] The character encoding of the request is: [null]. The
character encoding we will use for the request and response is:
[UTF-8]
2006-08-18 14:23:47,702 (TP-Processor3) [ ControlServlet.java:
126:DEBUG] [[[main] Servlet Starting, doing setup- total:0.0,since
last(Begin):0.0]]
2006-08-18 14:23:47,703 (TP-Processor3) [ ControlServlet.java:
175:DEBUG] [[[main] Setup done, doing Event(s) and View(s)- total:
0.0,since last([main] Servlet St...):0.0]]
2006-08-18 14:23:47,704 (TP-Processor3) [ RequestHandler.java:
203:INFO ] [Processing Request]: main
2006-08-18 14:23:47,705 (TP-Processor3) [ RequestManager.java:
114:INFO ] [RequestManager.getRequestAttribute] Value for attribute
"null" of uri "main" not found
2006-08-18 14:23:47,706 (TP-Processor3) [ RequestHandler.java:
386:INFO ] [RequestHandler.doRequest]: Response is a view.
2006-08-18 14:23:47,706 (TP-Processor3) [ RequestHandler.java:
538:INFO ] servletName=control, view=main
2006-08-18 14:23:47,707 (TP-Processor3) [ ScreenRenderer.java:
194:INFO ] Found session attribute that conflicts with parameter
name, leaving request parameter in place for name: externalLoginKey
2006-08-18 14:23:47,722 (TP-Processor3) [ ServiceDispatcher.java:
450:DEBUG] [[Sync service finished- total:0.013,since last(Begin):
0.013]] - 'partymgr / findParty'
2006-08-18 14:23:47,769 (TP-Processor3) [ ModelScreenWidget.java:
362:INFO ] In the include-screen tag the screen name was empty,
ignoring include; in screen [GlobalDecorator]
2006-08-18 14:23:53,976 (TP-Processor3) [ ControlServlet.java:
250:DEBUG] [[[main] Done rendering page, Servlet Finished- total:
6.272,since last([main] Setup done...):6.272]]
2006-08-18 14:24:41,021 (TP-Processor2) [ ControlServlet.java:
90 :INFO ] The character encoding of the request is: [null]. The
character encoding we will use for the request and response is:
[UTF-8]
2006-08-18 14:24:41,022 (TP-Processor2) [ ControlServlet.java:
126:DEBUG] [[[main] Servlet Starting, doing setup- total:0.0,since
last(Begin):0.0]]
2006-08-18 14:24:41,023 (TP-Processor2) [ ControlServlet.java:
175:DEBUG] [[[main] Setup done, doing Event(s) and View(s)- total:
0.0,since last([main] Servlet St...):0.0]]
2006-08-18 14:24:41,024 (TP-Processor2) [ RequestHandler.java:
203:INFO ] [Processing Request]: main
2006-08-18 14:24:41,025 (TP-Processor2) [ RequestManager.java:
114:INFO ] [RequestManager.getRequestAttribute] Value for attribute
"null" of uri "main" not found
2006-08-18 14:24:41,026 (TP-Processor2) [ RequestHandler.java:
386:INFO ] [RequestHandler.doRequest]: Response is a view.
2006-08-18 14:24:41,027 (TP-Processor2) [ RequestHandler.java:
538:INFO ] servletName=control, view=main
2006-08-18 14:24:41,028 (TP-Processor2) [ ScreenRenderer.java:
194:INFO ] Found session attribute that conflicts with parameter
name, leaving request parameter in place for name: externalLoginKey
2006-08-18 14:24:41,029 (TP-Processor2) [ PrimaryKeyFinder.java:
132:INFO ] Returning null because found incomplete primary key in
find: [GenericEntity:Product][productId,null()]
2006-08-18 14:24:41,252 (TP-Processor2) [ ServiceDispatcher.java:
450:DEBUG] [[Sync service finished- total:0.0010,since last(Begin):
0.0010]] - 'catalog / getProductCategoryAndLimitedMembers'
2006-08-18 14:24:42,732 (TP-Processor2) [ ControlServlet.java:
250:DEBUG] [[[main] Done rendering page, Servlet Finished- total:
1.708,since last([main] Setup done...):1.708]]
