Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Huge report to be displayed

 
Afroz Khan
Ranch Hand
Posts: 105
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a report which displays around 20 columns and 500+ rows. Sometimes the request times out as server does some sort of processing to display the report.

How can we manage here??

Thnx,
Afroz
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Afroz,

500 records is a bit much ammount of data in one page.Your request is likely to be timed out.

I would recommend to use paging in you application. A quick search on same forum and Jsp forum will give you a sufficient ammount of result for paging.

alternatively you can go for other options like you can generate PDF or Excel file server-side and user can download them

Shailesh
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Afroz,

If you still want to display 500 records in one page then you can go for compression filters.
As you explained that you request gets time out sometimes

so this may give you desired result

Shailesh
 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How long does the query take when executed directly. Returning 20 cols and 500 rows although a bit much shouldn't time out if the query is fast.
 
Afroz Khan
Ranch Hand
Posts: 105
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Shailesh & Steve,

I am doing some processing on the server side, so handling such data was a problem even for 100 records, but now I am doing processing using batch job and storing data in a table.

So the problem has come with the no. of rows, as its increasing day by day.

Can you refer some sites which can help me in getting paging information??

Thnx,
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Afroz Khan:

Can you refer some sites which can help me in getting paging information??



Search on JSP and JDBC forum for paging

Shailesh
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic