shanto
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.
15 replies
❔ Switching from Django to ASP. NET core
As the title says, I want to switch from python(django) to asp. NET core because of my company project requirements. I joined to company as a python developer. After seeing some code of ASP. NET core MVC,it seems pretty complex to me because of it's structured unlike python. So,Can you guys give me some advice about switching from one stack to another or switch to other company. If you think i should learn. NET,can you tell me approximate time needed to grasp the basics to advance. Do i have to suffer because of switching from python? And, It will be better if you share some good resource to learn ASP. NET core. I will need to learn it too quick.
10 replies