AravinthV Member since 2013 5 posts
Posted: 4 years ago
Last activity: 4 years ago

To generate reports having more than 100K records


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.

Moderation Team has archived post
Share this page LinkedIn