Hi,

We have a web application which populates reference data dropdowns from DB (such as country list, state list etc). We are using simple hibernate mapping with list queries. We are not using any collections and all our domain objects are simple java objects. We have enabled second level caching & query caching & setting "setCacheable" to true for the select queries. But the performance is very bad. (around 31 sec for 3500 rows).. The list queries seem to add stuff to the cache, but are not hitting the cache in subsequent queries. Every query is going to the database. "find" queries do seem to hit the database.

What could be the problem? We have less control on the way the DB is setup, are there any other tips to improve the performace thr' code?

Any help is appreciated,
Chana

Just wanted to give this one 'bump' in hopes that some new eyes had insight. Thanks.