I am currently having a query which fetches 12000 records from a database and it is a simple select query.
Iam storing this in a result set as we normally do and looping throgh it and displaying all 12000 records in a single page.The problem is it takes more than 15 minutes to load this page which shows all records.Can anysone please suggest if there is a way to speed up the response time.
One more thing...
I am displaying the results using out.println statement
something like this for eg..(out.print("<table width='900' align='absleft' border='1' cellspacing ='1' cellpadding ='1'>");)
The entire HTML tags are generated using out.println with in JSP..Is this a reason why this might be happening ?