the speed of my Excel Upload in Asp.net Core Application.. Am Uploading data in Excel into the database but is very slow, extremely slow.. Am using Angular at the Front End and ASp.net Core at the Back End, any idea as to how to make the Upload faster?
Can you convert it into json first and send jskn to server
put some stopwatch(es) and check which part is the slowest
how do i put it please
Read worksheet directly in list, don't read one by one. Then convert it to JSON and send json to sql server. Read json as view in sql server then you can bulk insert there. Using same way, I reduced time from more than 20 mins to few seconds for more than 45 k records
Обсуждают сегодня