aspose file tools*
The moose likes Object Relational Mapping and the fly likes Million record upload and diplay with pagination Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Million record upload and diplay with pagination" Watch "Million record upload and diplay with pagination" New topic
Author

Million record upload and diplay with pagination

G.Sathish kumar
Ranch Hand

Joined: Jul 27, 2009
Posts: 84
i am using spring hibernate.

I need to upload million record in sql server database and need to display it in the fron end pages with pagination.

please tell me which technique to follow up to upload million record and about to display is there any local object technique available to process the pagination.


Thanks
Sathish kumar
SCJP, SCWCD
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Don't use Hibernate to upload your data. The bulk loader tools supplied with your database will do it much more efficiently.

Hibernate has its own pagination mechanism (see this). Be aware that if the database itself doesn't supply the mechanisms to implement this efficiently you will in effect be returnign the entire million records then filtering. Check your database documentation on pagination.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
G.Sathish kumar
Ranch Hand

Joined: Jul 27, 2009
Posts: 84
ok thanks.

Do you know any tools about bulk uploader for SQL server 2005

Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Yes. SQL Server has transact SQL commands to do this. Check the docs on BULK INSERT.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Million record upload and diplay with pagination