Performance degradation during Exporting Data
Hi, Hope you guys are doing well.
So, I need help. I have an application that has suppose 10000 of data. My business requirement is to download 1000 documents in excel and word.
What the client side does is :
Suppose an author has 1500 books
So,to export it
Download 1 - 1000 (call api with page number 1 and pagesize 1000)
Download 1001 - 1500 (call api with page number 2 and pagesize 500)
*Note - users can download with one criteria above once i.e. One api call.
So, what i was doing is to call the database with 1000 pagesize in repository and then bind in service and then send it to export api that will export those data as excel / word. But it is taking too much time. There are lakhs of users that use our application daily. So, it is a great degradation in performance. What can i do? And yes,those generated data contains image, css,tables too and i am using openxml sdk. Is there any suggestion of improvement. And yes i am using memory stream and returning those data as byte array.
So, I need help. I have an application that has suppose 10000 of data. My business requirement is to download 1000 documents in excel and word.
What the client side does is :
Suppose an author has 1500 books
So,to export it
Download 1 - 1000 (call api with page number 1 and pagesize 1000)
Download 1001 - 1500 (call api with page number 2 and pagesize 500)
*Note - users can download with one criteria above once i.e. One api call.
So, what i was doing is to call the database with 1000 pagesize in repository and then bind in service and then send it to export api that will export those data as excel / word. But it is taking too much time. There are lakhs of users that use our application daily. So, it is a great degradation in performance. What can i do? And yes,those generated data contains image, css,tables too and i am using openxml sdk. Is there any suggestion of improvement. And yes i am using memory stream and returning those data as byte array.
