Base solution for your next web application
Open Closed

Very slow procedure on importing users from excel #8891


User avatar
0
rdcinformatics created

Hello,

we are using aspnetzero v.8.0 for our multitenant application. We need to import thousands of users from excel in specific times of the year. We test the import with 10000 users and we are very disappointed from the performance and the time it takes. We stopped the procedure on 40 minutes. The import started with 2 users per second and on 30 minutes it has come to 0.7 per second (only 2000 users imported) and as we noticed it is always getting reduced as the time passed. Is it another way to do this import more quickly (using for example sqlbulkcopy)?


1 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team

    hi @rdcinformatics

    I created an issue, you can follow it.

    https://github.com/aspnetzero/aspnet-zero-core/issues/3188