none
Performance impact in Creation of Excel file with Huge data Records ( 1 lak records)

    Question

  • Hi

    we are using the openxml  sdk in building the excel file at runtime which was consuming bit high memory with normal load of around 100 records and it takes close to 1 min - 3 min time intervals based on the load. Now we need to support the file generation with 1 lak records data and we see a huge spike in the memory and this is blocking the other operations.. 

    is there any settings which can help us on file generation with less memory consumption even on huge data insertions into excel .

    Thanks,

    Manoj


    Thanks, Manoj

    mardi 29 mai 2018 21:55

Toutes les réponses

  • Hello Manoj Mathe,

    How do you design your application? What's your code? 

    By the way, what is  "lak"? Is it a special unit?

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    mercredi 30 mai 2018 10:04
    Modérateur