Hello,
I am using Aspose.Nets.Cells (23.8.2.0) and Aspose.Cells.GridWeb (23.8.2.0) on a c# webforms app and hosted the site on a server. We are getting complaints from the users saying the site is being slow and sometimes crashes as well. We would like to know how much of the resources are being used from the server vs client. Mainly What we believe these things require server resources:
• Loading the sheets (anytime you move from sheet to sheet or open the template)
• Saving the sheet
• Creating/viewing/editing a deal, customer, user, etc
• Creating PDFs
What we believe these things require client resources:
• Entering data on sheets
• Macros that are driven by events like drop downs
• Anything on a sheet that is simply using the excel features
First of all, we would like to know if you are experiencing performance or slowness issues with Aspose.Cells APIs or with Aspose.Cells.GridWeb. Both Aspose.Cells (library) and Aspose.Cells.GridWeb (control) are server-based components, so they primarily utilize the server’s resources. The server should be equipped with sufficient resources such as CPU, memory (RAM), storage (hard disk drives or SSDs), and network connectivity.
Regarding the Aspose.Cells.GridWeb control, you might encounter slowness issues when loading a large Excel file (with a huge list of data in different worksheets) into the GridWeb matrix and manipulating data by navigating to different sheets. Anyways, could you please provide a standalone sample project with sample files to demonstrate the issue? We will check it soon.