• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Huge report to be displayed

 
Ranch Hand
Posts: 105
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 1087
Oracle Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 1087
Oracle Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 1087
Oracle Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic