What is the Best way to write high volume of data into database

Certified Senior Developer

Hi All,

I have an interface where we are having paragraph field and grid . User will be giving data in the paragraph field in specific format and will click on add button, Once they clicked on it, it will be written into database and the grid will be refreshed with the added data. There are some use cases where user will be adding more than 2000 records at a time. Currently it is taking around 2 minutes to load the 500 records into database.  What is the best way to save the data into database with minimal time? Could someone please help me on this

  Discussion posts and replies are publicly visible