hi, ive been working on a ejb3 application that need to cache as much as possible. queries are cached manually by storing the result (only the primary keys) in jbosscache (the same cache as the entity beans).
when that query is called again we fetch the id's from cache and for each id we just call EntityManager.find(Class, id). most of the objects are loaded into the cache at this point, so there are zero db calls. this works very well, but it doesnt perform as good as we hoped.
a resultset of 1000 objects take 200ms when we call EntityManager.find(...) for each id, but if we call the cache directly for each entry it takes about 20ms in total (but we really do not want to do this).
and if we do the query "normally" (without any caching) it performs better than if we call EntityManager.find(...) for each entry, about 50-80ms.
are there any way to speed up the EntityManager.find(..) call?
IsolationLevel is none and CacheMode is local.

i understand that the easy solution is to not cache queries, but if we dont the database will crumble down in notime and i would rather not use the hibernate query cache since that would eat up cachememory very fast (since we also have entity cache).

i posted this in the JBoss EJB3 forums earlier without any responses so im trying my luck here. any input would be highly appreciated..

I don't know exactly what is taking time. Are you using a clustered cache?
I guess you should use a profiler to dig the issue.