We are uploading 3 files and data is inserting into database. While uploading the file, it's taking very long time. As per checking, it's taking time while committing in database. We have not faced similar issue in lower environments. When we deployed into production, when we are trying to upload the files, it's taking very long time in production environment only.
Earlier version of database, these columns are not available like pzInsKey, pxCreateDateTime, pxCommitDateTime, pxInsName, pxSavedDateTime and pxUpdateDateTime. Once we deployed the package into production, data is inserting for the above columns into database. Only latest data is inserting which we are trying to upload and older data are having null values.
Can you please help me why only in production once we deployed, it's taking time to upload the files. To insert 369 records, it's taking almost 30-40mins. In lower environments, data used to upload within 2-3 seconds.
Kindly help in in this regards to resolve the issue. Thank you.
***Edited by Moderator Marissa to update Content Type from Discussion to Question***