Total Time taken for CSV to Database Import

Hello

We are using Appian 17.4 to bulk upload csv data to a sql server database. We are achieving it by using ‘Import CSV to Database’ smart service to import the data to the database.

One of the csv file has 6 columns and around 20k records. There is no data transformations.

Below 2 issues:

Access Denied Error:
While we upload the csv containing around 20k rows, the data is successfully inserted to the database. Though after successful upload, it shows ‘403 Access Denied’ error on the screen.

Total Upload time:
The time to upload the csv containing 5k rows at a time is taking around 5 minutes which seems to be a bit high. This is obvious with the reason that Appian is communicating to different server writing the data.

Is there any way or alternate to reduce the time taken to upload the data to the database?

Thanks

Nirav