Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Using Query cache and second level cache

 
ram shyam
Ranch Hand
Posts: 77
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I would like to know if the following is possible to achieve using query cache mechanism.

Being a fresher to Hibernate, I understood the basic purpose of using query cache, ie, to fetch the data from the cache instead of fetching from the DB each and every time which increases the performance.

My requirement is as follows-
I fetch a set of 10 records from the DB and cache them using query cache and second-level cache. Now, would it be possible to fetch next or previous set of 10 records using already cached identifier values? If possible, could you please let me know how it can be achieved?
If not, is there any other means to achieve this?

Thanks in advance!!
[ May 10, 2007: Message edited by: deepa gr ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34401
346
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving this to our ORM forum since it has to do with Hibernate.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"ram_shyam"

Please click on the My Profile link above and change your display name to meet the JavaRanch Naming Policy of using your real first and real last names, and no underscores.

Thanks

Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic