• Post Reply Bookmark Topic Watch Topic
  • New Topic

Slow page loading when thousands of records are fetched  RSS feed

 
Sijohn Thomas
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, I am using struts and mysql. My page loads very slow when around 1500 records are fetched. I debugged the code and found that the query executes fast and even in the jsp, the iteration happens fast. The debugger traversed throught the jsp pretty fast and the delay comes after the traversal through the jsp page. Can anybody help me with what could be the problem here and possible solution.. Thanks.
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 65833
134
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That's way too much data to try and display. I suggest paging the results into smaller, digestible chunks. See theJSP FAQ for info on how to page data.
 
Mohamed Sanaulla
Bartender
Posts: 3169
34
Google App Engine Java Ruby
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I had this link on my bookmarks, so thought of providing it: http://www.coderanch.com/how-to/java/PaginationOrPaging
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!