CMP, Cache, and Performance Degradation

[asharzaman]

I have a CMP Entity which contains 18000 entries in the DB. On my first findAll() call, it takes only 2 seconds to return a collection with all of the data. If I make another call, after the initial call, to the same bean, it takes 87 seconds to return the same data. My cache is set to 1000000 beans, and I have 512 MB of RAM (no shortage). I am using DB2 as the database on W2K. Can someone please tell me what I am missing

Thanks

[benw]

I am having the same problem. I have an entity that contains 976 records. With commit option A and read-ahead set to either on-load or on-find, the findAll() call basically gets all the data from the database the first time around (which is fine). However, when I tried to access the data the 2nd time, it took over 40 secs to return the data from the cache. I tested this using JBoss 3.0.0 final and JBoss 3.0.1 rc1. JBoss 3.0.0 final was even taking longer, often over 90 seconds for the data to come back from the cache.

Any insights on this will be greatly appreciated,
Ben

[asharzaman]

[dsundstrom]

Are you sure this is in the entity cache? If so, I suggest you bring this up on the JBoss-dev list.

[asharzaman]

may be i don't know how to set the entity-cache. I was thinking that list-cache-max is how it was set. can someone please tell me where and how to setup entity cache.

thanks

[dsundstrom]

list-cache-max is a query results cache. The bean cache is controlled by the jboss.xml file. I don't know the setting but look for the cache section.