I'm trying to insert multiple rows from an Excel file into my DB but every insert takes about 4-5 seconds when running it from Forge. Using my local dev env works fast without any trouble.
It's really hard to help you here without more information. How do you process the files, how do you insert the records? Do you load everything in memory first and then process? What kind of production server do you use?
I'm using Maatwebsite/Laravel-Excel to process a XLSX file with two columns and store them into an array, then I use a foreach to insert every row one by one, every insert takes about 5 sec.
I'm running a Linode server ($10), PostgreSQL 11, Laravel 5.7 and everything is deployed from Forge. Have to say that running this in my laptop with the same DB doesn't take that long in every insert, also working with MySQL does fast inserts, just PostgreSQL in production server got this problem :(