I have a thick client that I need to increase performance for. The client has a local database which it runs the exact query for with the a small subset of parameters. From the documentation I thought that query cacheing might be appropriate???

Also what is the best second level cache for this thick client if I need query performance and it doesn't matter If I get stale data for a small amount of time? I saw suggestions on a site that HQL will always be retrieved from the database and not the cache. Is this the case??? I didn't think so (And am hoping that this is not the case).

Any suggestions for settings where the number 1 priority is on performance would be appreciated,

Scott