Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Million record upload and diplay with pagination

 
G.Sathish kumar
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
G.Sathish kumar
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ok thanks.

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

 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes. SQL Server has transact SQL commands to do this. Check the docs on BULK INSERT.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic