Hibernate version: 3.0

Name and version of the database you are using: Sybase 12.5

SecondLevelCache Ehcache 1.2.4

CPU/Memory Intel P4 2.8Ghz / 1GB


I'm not sure if I'm alone in this but I'm experiencing pretty slow performance rebuilding object graphs from the Query Cache.

The resultset consists of 5000 parent objects each containing a collection of ~ 40 child objects. The initial query takes around 30 seconds to fetch both parents and children.

However, subsequent runs of the query are using the query and second level caches and are taking 6-8 seconds to return. Is this kind of performance considered acceptable for this volume of data when it's already in memory?

My CPU performance during the fetch from cache is ~ 50% and I still have lots of memory available.