hibernateではsetFirstResult、setMaxResultsなどで取得時の件数を指定できます。
SQLにlimitやoffsetが付いた形で発行されるので、結果セットが膨らまず、有効です。
しかし、コレクションに対してfetch joinしている場合には件数が狂います。
対策としてはlazyにするか、結果セットのリストを自分でsubListする、などになります。
« HQLからSQL | メイン | DetachedCriteriaとCriteria »
hibernateではsetFirstResult、setMaxResultsなどで取得時の件数を指定できます。
SQLにlimitやoffsetが付いた形で発行されるので、結果セットが膨らまず、有効です。
しかし、コレクションに対してfetch joinしている場合には件数が狂います。
対策としてはlazyにするか、結果セットのリストを自分でsubListする、などになります。
このエントリーのトラックバックURL:
http://www.grandnature.net/bin/mt-tb.cgi/74
コメント (30)
I am very made up I discovered this article. Cheers for your effort for this great read! I have you saved to check out the new stuff you blog about.
投稿者: mon cheri uk | 2011年11月30日 03:58
日時: 2011年11月30日 03:58
Do you mind if I quote a few of your articles as long as I provide credit and sources back to your website? My blog is in the very same niche as yours and my users would truly benefit from a lot of the information you provide here. Please let me know if this okay with you. Cheers!
投稿者: Juana Scharbach | 2011年12月01日 04:21
日時: 2011年12月01日 04:21
It seems too complicated and very general for me to understand.
投稿者: LV bags | 2011年12月02日 00:49
日時: 2011年12月02日 00:49
I’m really influenced with your writing talents well with the structure for your blog site.keep up the nice quality writing, it’s uncommon to look a nice blog like this one these days.
投稿者: coach outlet online | 2011年12月02日 01:58
日時: 2011年12月02日 01:58
Thanks for all of your hard work on this blog. My mom takes pleasure in going through investigation and it is obvious why. A number of us notice all regarding the dynamic ways you convey invaluable techniques through the web blog and as well cause contribution from other ones on this subject matter plus our girl has always been becoming educated a lot of things. Take advantage of the rest of the year. You're the one carrying out a superb job.
投稿者: air max | 2011年12月03日 05:19
日時: 2011年12月03日 05:19
neat stuff, i really enjoyed it.
投稿者: BLENDERS | 2011年12月07日 01:34
日時: 2011年12月07日 01:34
Hello there! Nice post! But the site is loading pretty slowly.
投稿者: womens watches | 2011年12月07日 09:00
日時: 2011年12月07日 09:00
Hey there! Good post! But this webpage is still loading pretty slowly.
投稿者: womens watches | 2011年12月07日 11:19
日時: 2011年12月07日 11:19
Zune and iPod: Most people compare the Zune to the Touch, but after seeing how slim and surprisingly small and light it is, I consider it to be a rather unique hybrid that combines qualities of both the Touch and the Nano. It's very colorful and lovely OLED screen is slightly smaller than the touch screen, but the player itself feels quite a bit smaller and lighter. It weighs about 2/3 as much, and is noticeably smaller in width and height, while being just a hair thicker.
投稿者: polos | 2011年12月07日 12:35
日時: 2011年12月07日 12:35
You should be a part of a contest for one of the best websites online. For certain I will recommend this blog!
投稿者: hogan outlet | 2011年12月08日 19:00
日時: 2011年12月08日 19:00
I’m really influenced with your writing talents well with the structure for your blog site.keep up the nice quality writing, it’s uncommon to look a nice blog like this one these days.
投稿者: coach outlet online | 2011年12月10日 11:11
日時: 2011年12月10日 11:11
I like Your Article about Sun Damaged to "Sun Virgin"! Perfect just what I was searching for! .
投稿者: filter paper whatman | 2011年12月13日 07:34
日時: 2011年12月13日 07:34
Just want to say your article is as astounding. The clarity in your post is simply excellent and i could assume you're an expert on this subject. Well with your permission allow me to grab your RSS feed to keep up to date with forthcoming post. Thanks a million and please keep up the enjoyable work.
投稿者: Jasmin Hemminger | 2011年12月13日 21:08
日時: 2011年12月13日 21:08
An fascinating speech is designer observe. I reckon that you should correspond author on this matter, it power not be a sacred thing but generally group are not enough to verbalise on specified topics. To the next. Cheers like your 件数ã®æŒ‡å®š (GrandNature).
投稿者: invest liberty reserve | 2011年12月14日 02:28
日時: 2011年12月14日 02:28
Definitely this blog is very informative and neatly designed. Really you've motivated me strongly in my new project by this article. As a constant reader of your blog I want to tell you that your writing skills are superb.
投稿者: Emanuel Taliulu | 2011年12月14日 14:57
日時: 2011年12月14日 14:57
If you're still on the fence: grab your favorite earphones, head down to a Best Buy and ask to plug them into a Zune then an iPod and see which one sounds better to you, and which interface makes you smile more. Then you'll know which is right for you.
投稿者: mbt shoes sale | 2011年12月15日 17:46
日時: 2011年12月15日 17:46
Hi! Wonderful post! But the webpage is still loading pretty slowly.
投稿者: womens watches | 2011年12月18日 01:12
日時: 2011年12月18日 01:12
I'm commenting to make you understand of the terrific encounter our princess found going through your web site. She even learned many things, not to mention what it's like to have a great teaching character to get many others easily know precisely chosen advanced subject areas. You actually exceeded our expected results. Thanks for delivering such priceless, safe, explanatory as well as cool tips about that topic to Evelyn.
投稿者: vps hosting | 2011年12月19日 10:39
日時: 2011年12月19日 10:39
Great. I learn something new on different blogs everyday. It will always be stimulating to see content from other bloggers. I’d love to share with the content on my blog if you don’t mind. Naturally I’ll put a link on your blog, let me know if you're interested!
投稿者: purple bridesmaid dresses uk | 2011年12月19日 21:35
日時: 2011年12月19日 21:35
out of almost all the blogs ive read through, such as this blog but not to get off topic -- however to truly create change monetarily a person must rely on themselves above all else
投稿者: extraction thimbles | 2011年12月20日 14:19
日時: 2011年12月20日 14:19
Magnificent goods from you, man. 件数ã®æŒ‡å®š (GrandNature) I've understand your stuff previous to and you're just extremely great. I really like what you've acquired here, certainly like what you are stating and the way in which you say it. You make it entertaining and you still care for to keep it sensible. I can not wait to read much more from you. This is really a tremendous 件数ã®æŒ‡å®š (GrandNature) informations.
投稿者: invest liberty reserve | 2011年12月21日 04:26
日時: 2011年12月21日 04:26
Hey very cool web site!! Man .. Beautiful .. Amazing .. I'll bookmark your blog and take the feeds also…I am happy to find so many useful info here in the post, we need develop more techniques in this regard, thanks for sharing. . . . . .
投稿者: vps hosting | 2011年12月21日 14:58
日時: 2011年12月21日 14:58
It seems too complicated and very general for me to understand.
投稿者: cheap coach handbags | 2011年12月21日 20:16
日時: 2011年12月21日 20:16
I got what you signify, thanks for putting up. Woh I am glad to feel this website through google. Thanks For Share 件数ã®æŒ‡å®š (GrandNature).
投稿者: LA Weight Loss | 2011年12月22日 19:31
日時: 2011年12月22日 19:31
Thanks for all of your hard work on this blog. My mom takes pleasure in going through investigation and it is obvious why. A number of us notice all regarding the dynamic ways you convey invaluable techniques through the web blog and as well cause contribution from other ones on this subject matter plus our girl has always been becoming educated a lot of things. Take advantage of the rest of the year. You're the one carrying out a superb job.
投稿者: Coach Factory Outlet | 2011年12月22日 23:06
日時: 2011年12月22日 23:06
Thanks for one's marvelous posting! I quite enjoyed reading it, you happen to be a great author.I will always bookmark your blog and definitely will come back later in life. I want to encourage yourself to continue your great work, have a nice morning!
投稿者: vps hosting | 2011年12月23日 10:02
日時: 2011年12月23日 10:02
This is getting a bit more subjective, but I much prefer the Zune Marketplace. The interface is colorful, has more flair, and some cool features like 'Mixview' that let you quickly see related albums, songs, or other users related to what you're listening to. Clicking on one of those will center on that item, and another set of "neighbors" will come into view, allowing you to navigate around exploring by similar artists, songs, or users. Speaking of users, the Zune "Social" is also great fun, letting you find others with shared tastes and becoming friends with them. You then can listen to a playlist created based on an amalgamation of what all your friends are listening to, which is also enjoyable. Those concerned with privacy will be relieved to know you can prevent the public from seeing your personal listening habits if you so choose.
投稿者: Louis Vuitton Outlet | 2011年12月23日 16:21
日時: 2011年12月23日 16:21
hey there and thank you for your info – I have definitely picked up something new from right here. I did however expertise a few technical points using this site, as I experienced to reload the website many times previous to I could get it to load correctly. I had been wondering if your hosting is OK? Not that I am complaining, but slow loading instances times will very frequently affect your placement in google and can damage your high-quality score if advertising and marketing with Adwords. Well I am adding this RSS to my e-mail and could look out for much more of your respective fascinating content. Make sure you update this again very soon..
投稿者: Yun Redstone | 2011年12月25日 11:56
日時: 2011年12月25日 11:56
I'll gear this review to 2 types of people: current Zune owners who are considering an upgrade, and people trying to decide between a Zune and an iPod. (There are other players worth considering out there, like the Sony Walkman X, but I hope this gives you enough info to make an informed decision of the Zune vs players other than the iPod line as well.)
投稿者: Louis Vuitton Outlet | 2011年12月25日 16:07
日時: 2011年12月25日 16:07
How do you do? our family just loves your amazing blog thanks and pls keep it up
投稿者: filter paper | 2011年12月26日 14:59
日時: 2011年12月26日 14:59