Hibernate Community • View topic - setFirstResult argument is too small, don't everybody think?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

setFirstResult argument is too small, don't everybody think?

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

anthon.r

Post subject: setFirstResult argument is too small, don't everybody think?

Posted: Sat Apr 07, 2007 2:42 am

Beginner

Joined: Fri Jan 27, 2006 4:20 am
Posts: 22

Hey, I need to pass a huge value to setFirstResult, probably 5 billion or more. They should overload that function to include a long type argument.. who's with me?

Top

david

Post subject:

Posted: Sat Apr 07, 2007 3:39 am

Hibernate Team

Joined: Tue Aug 26, 2003 7:19 pm
Posts: 2364
Location: Brisbane, Australia

Yes and No.

Yes - semantically I would agree a long is better. This is also supported by the recent (correct) change to the return type for the ' count(*)' select clause in HQL.

No - as paging implementations by DBs often becomes less efficient as the starting point increases. If your paging starts-at/get-to-the 5 billion'th record then maybe an alternative should be used.

I would suggest you create a JIRA entry and see if it flys.

Top

anthon.r

Post subject:

Posted: Wed Apr 11, 2007 11:51 pm

Beginner

Joined: Fri Jan 27, 2006 4:20 am
Posts: 22

Code:

No - as paging implementations by DBs often becomes less efficient as the starting point increases. If your paging starts-at/get-to-the 5 billion'th record then maybe an alternative should be used. 

Is that really sufficient reason to set a limitation? Can we make it a bit forgiving? Why don't let the user suffer the consequences? What if a RDMS optimally implements paging?

I'm new to this community, I don't know if it is appropriate for me to add entries to JIRA.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum