Does query cache work with query.setMaxResults()?

jhudson8 · **Posted:** Fri Mar 25, 2005 3:36 pm

Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 2.1.8

Hello, I am using the MySQL dialect with query cache enabled. I have show SQL set to true.

I have noticed that if I do not call query.setMaxResults(), the SQL does not print to the console (because it wasn't run since it was found in 2nd level cache). However, if I use the same query but call query.setMaxResults(10), the SQL does print out so, it is being called again.

Is there anything I can do to make query cacheing work in conjunction with setMaxResults? Any help would be greatly appreciated. Thank you very much.

Joe

max · **Posted:** Fri Mar 25, 2005 5:01 pm

without being able to check the code right now i would guess that the value of maxresults is used as part of the key to identify what result the query matches too.

what happens if you execute the same query wiuth the same maxresult - is it still executed ?

jhudson8 · **Posted:** Fri Mar 25, 2005 5:16 pm

Thanks very much for the reply Max.

I was actually wrong with my previous message, this is what it really is..
Performing query.list() does listen to the cache and performing query.scroll() does not.

Here is a simple little example:

Code:

      System.out.println("I'm checking the first query..");
      Query query = getNamedQuery(QUERY_MESSAGE_BOX_MESSAGES, messageBox
            .getId());
      query.setCacheable(true);
      query.list();
      
      System.out.println("I'm checking the second query..");
      query = getNamedQuery(QUERY_MESSAGE_BOX_MESSAGES, messageBox
            .getId());
      query.setCacheable(true);
      query.scroll();

And, here is the output:

Code:

10:58,779 INFO  [STDOUT] I'm checking the first query..
11:02,092 INFO  [STDOUT] I'm checking the second query..
11:05,561 INFO  [STDOUT] Hibernate: select message0_.message_id as message_id, case when message0__1_.voice_message_id is not null then 1 when message0__2_.email_message_id is not null then 2 when message0_.message_id is not null then 0 end as clazz_, message0_.status as status25_, message0_.created_date as created_3_25_, message0_.storage_size as storage_4_25_, message0_.message_box_id as message_5_25_, message0__1_.message_length as message_2_26_, message0__1_.from_phone_number as from_pho3_26_, message0__2_.text_data as text_data27_, message0__2_.from_address as from_add3_27_, message0__2_.from_name as from_name27_, message0__2_.subject as subject27_, message0__2_.is_html as is_html27_ from message message0_ left outer join voice_message message0__1_ on message0_.message_id=message0__1_.voice_message_id left outer join email_message message0__2_ on message0_.message_id=message0__2_.email_message_id, message_box messagebox1_ where (message0_.message_box_id=? )and((messagebox1_.greeting_id is null  and message0_.message_box_id=messagebox1_.message_box_id)or(messagebox1_.greeting_id<>message0_.message_id  and message0_.message_box_id=messagebox1_.message_box_id)) order by  message0_.created_date desc

max · **Posted:** Fri Mar 25, 2005 5:22 pm

i dont think scroll() should use the cache since it should return a scrollable resultset to you ....and that we need to fetch from the db.