It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes is there a way for data paging without count in oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "is there a way for data paging without count in oracle" Watch "is there a way for data paging without count in oracle" New topic
Author

is there a way for data paging without count in oracle

Eric Shao
Greenhorn

Joined: Jan 13, 2008
Posts: 5
I used hibernate to implement Data paging

but I must execut count(*) every time, it will decrease the performance of db

so anybody can give me some advice or example SQL for oracle datapaging without count

getting paging data and total once time

thanks in advance


PMP
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 32507
    
214

"J'male",
Please check your private messages for an important administrative matter.


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: is there a way for data paging without count in oracle
 
jQuery in Action, 3rd edition