After some additional testing, 12.04 is an average of 5 times slower than 9.04 across a range of services that use various entity engine calls.
This has to be a configuration problem. Anyone have a pointer? Skip -----Original Message----- From: Skip [mailto:s...@thedevers.org] Sent: Tuesday, June 25, 2013 5:24 PM To: OfbizUser Subject: Obfiz 12.04 way slower than 9.x I am trying to upgrade to 12.04. On a test machine I finally got it all running. However, it all seems to drag in 12.04 as compared to version 9.04 or something. When I click on Entity Engine Maintenance, the entity list comes up instantly in 9.04 and takes 12 seconds to render in 12.04. Although this customer does not use it, the home page in ecommerce comes up instantly in 9.04 and takes the same 12 seconds in 12.04. (I am guessing that this is because of the different handling of catagories because part of the page comes up instantly.) I have this service that processes the inventory with a findListIteratorByCondition and does a few findByPrimaryKeys on the list, then writes a text file (no entity engine calls). This service takes 11 seconds to run in 9.04 and 28 seconds in 12.04. This is almost 3 times slower and this is entirely java code with no screen stuff. I also expect that a significant portion of that time is in the disk io writing the the text file, so I expect that the entity engine calls are something like 4 times slower. This is on an 8 core machine with 64 gigs of memory and a really fast hard disk array. I have the cache, debug and logging set the same. Both instances are using the same postgres database except that the 12.04 is using postnew. Neither instance has anything in the log at the conclusing, and both produce exactly the same results. Both ofbiz instances are running Minerva. I am getting ready to run a profiler on this to see where the slowdown is, but maybe I do not have a setting right for production. Am I missing something? Skip