The entitycache information is nice and all, but to isolate a problem like this a lot more information is needed. You could try sending it here and see if people will comment, but you might have more success reading comments about performance and understanding the various factors and then you'll be able to see the problem(s) as you're looking into things.

For the cache: the more important ones are the configuration and source caches, like ftl and bsh files, and the various widgets and so on.

-David


On Sep 19, 2006, at 11:46 AM, Vijay Korimilli wrote:


I did do JMeter performance tests
http://www.nabble.com/Ofbiz-caching---JMeter-Performance-results-on- Ofbiz-eCommerce-store-tf2290974.html There is a correction to the thread, we are using the following hardware: dual Opteron 248. Cent OS, The OS is 64bits, 4 GB RAM and U320 SCSIs, JVM -
1.4.2_08
The database server is mysql 5.0

I am still chasing the performance problem for our Ofbiz server. I am
assuming the benchmark test results for such hardware are not upto
expectations.

If anyone has any specific suggestions, it would be of great help.

In the cache management tool, I see the following (this is random
observation, and not particularly after the tests):
entitycache.entity-list.default.PartyAndUserLogin 0 0 57/57/0/0 0/0 0 0 true
Elements  Edit  Clear
entitycache.entity-list.default.PartyMailer 35 40 77/73/0/4 0/0 0 0 true
Elements  Edit  Clear
entitycache.entity-list.default.PartyProductInfo 2 0 3/3/0/0 0/0 0 0 true
Elements  Edit  Clear
entitycache.entity-list.default.ProdCatalogCategory 1 5,443 31/16/0/15 0/0 0
0 true Elements  Edit  Clear
entitycache.entity-list.default.ProdCatalogRole 20 14 41/40/0/1 0/0 0 0 true
Elements  Edit  Clear
entitycache.entity-list.default.Product 0 156 1,403/1,403/0/0 0/0 0 0 true
Elements  Edit  Clear
entitycache.entity-list.default.ProductAndCategoryAndAttribute 1 456
1,693/1,693/0/0 0/0 0 0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductAndProductAttribute 1 3,162
3,430/3,430/0/0 0/0 0 0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductAssoc 962 10,602 5,331/3,630/0/1,701
0/0 0 0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductAttribute 10 40 199/179/0/20 0/0 0 0
true Elements  Edit  Clear
entitycache.entity-list.default.ProductCategory 0 46 95/95/0/0 0/0 0 0 true
Elements  Edit  Clear
entitycache.entity-list.default.ProductCategoryDigiContentType 0 1 59/59/0/0
0/0 0 0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductCategoryMember 451 484
1,894/1,400/0/494 0/0 0 0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductCategoryRollup 6 1,708 71/41/0/30 0/0
0 0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductContent 2,026 887 7,805/5,932/0/1,873
0/0 0 0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductDetailAndProductCategory 0 30
919/919/0/0 0/0 0 0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductDigitalContent 2 8 13/8/0/5 0/0 0 0
true Elements  Edit  Clear
entitycache.entity-list.default.ProductDigitalContentType 1 11 9/5/0/4 0/0 0
0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductFeatureAndAppl 479 707
2,660/1,810/0/850 0/0 0 0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductPrice 1,562 12,862
11,646/7,386/0/4,260 0/0 0 0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductPriceType 1 0 3/3/0/0 0/0 0 0 true
Elements  Edit  Clear
entitycache.entity-list.default.ProductReview 1,560 12,370
11,630/7,376/0/4,254 0/0 0 0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductStoreCatalog 1 4,036 8/5/0/3 0/0 0 0
true Elements  Edit  Clear
entitycache.entity-list.default.ProductStoreGroup 1 0 3/3/0/0 0/0 0 0 true
Elements  Edit  Clear
entitycache.entity-list.default.ProductStorePromoAppl 1 349 89/45/0/44 0/0 0
0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductStoreSurveyAppl 2 6,459 40/22/0/18
0/0 0 0 true Elements  Edit  Clear
entitycache.entity-list.default.ProductType 1 12 39/20/0/19
entitycache.entity.default.Product 1,417 32,876 7,342/3,517/0/3,825 2,085/29
0 0 true Elements  Edit  Clear
entitycache.entity.default.ProductAttribute 16 5,472 215/15/0/200 0/41 0 0
true Elements  Edit  Clear
entitycache.entity.default.ProductCategory 59 20,837 814/58/0/756 0/0 0 0
true Elements  Edit  Clear
entitycache.entity.default.ProductFacility 1,560 16,622 1,561/1,561/0/0 0/0
0 0 true Elements  Edit  Clear


Thanks,
Vijay.




Fabian Gorsler wrote:

Hi David,


In general the entity engine performance test page in webtools is not
a good predictor for web site performance because it is not really
similar in any way to what happens in real-world use of an
application.

that's totally correct, but we just wanted to see anything on how OFBiz
performs. At least we know now, that something is strange with that
machine, because creating instances of e.g. HashMaps is slower and it
seems to be that each method call on this machine takes more time than on
other environments. Perhaps we should upgrade the JVM. We'll see.

The best thing to do is have a separate box (or a number of separate
boxes...) run something like JMeter to do page requests and sessions
that are similar to real world usage. There are various open source
and commercial tools for this and for any performance test this is
the only way to go.

Yes, that is our current plan. Yesterday I've read a bit about The
Grinder, which was proposed on this list a few days ago, and today I want
to try it.

If you plan on having any sort of load on your servers doing this
sort of thing should be considered necessary. If you find performance
problems explaining and fixing them requires a lot of knowledge,
basically about every piece of software and hardware involved. With a bit of optimization you can often dramatically improve results though...

Exactly that's the point why I've posted the issue to this list. I hope I'll find the problem. If I can say I've found it, I'll post my results.

Thanks for your answer.

Best regards,
Fabian.




--
View this message in context: http://www.nabble.com/Entity-Engine- Performance-tf2252097.html#a6393475
Sent from the OFBiz - User mailing list archive at Nabble.com.


Reply via email to