title: Fetching data in small units instead of fetching at a time
body: <p>I'm currently working on a Struts 2 application with Spring as backend with MySQL database.<br>
  Right now fetching 1000+ rows on page load.<br>
  I'm using tablesorter jquery plugin for displaying the results,sorting on click and pagination purpose.<br>
  But the page is taking lot of time to load and also it hangs in IE !!<br>
  Is there any easier way to do this like fetching required data from database as and when the user makes the selection like fetch first 10 rows,sorting data,etc.<br>
  Any ideas to make the application work faster are welcome !!</p>