Question

2
Replies
543
Views
Close popover
Aravinth Venkateshwaran (AravinthV)
Accenture

Accenture
IN
AravinthV Member since 2013 5 posts
Accenture
Posted: August 25, 2016
Last activity: August 29, 2016
Closed

To generate reports having more than 100K records

Hi,

In our application, we are using a SOAP service to invoke the java from websphere which will generate the excel file, and will upload to the content manager as a zip file to reduce the downloadable file size.  

System  generate a report with around 80 columns and 65K or more records depends on user entries.  If the entries are more than 66K, xls file will not accommodate and will fail. Hence system enhancement was made to generate reports in xlsx format to increase the row count, but here we are facing many problems like time out issue, memory issues, hung thread creation, etc., we increased the SOAP response time and increased the server memory, still when we are trying for 100K records for testing its failing of memory issue and hung threads creation, application becomes fully down at this time. Can anyone please suggest any alternative way for creating this report.

Reporting
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.