Question
Standard Chartered Bank
IN
Last activity: 15 Jun 2020 17:09 EDT
File upload issue while committing in DB
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.
Observations:
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***
Updated: 15 Jun 2020 17:09 EDT
Standard Chartered Bank
IN
Hi Paul, thanks for the reply, find the comments below:
Are you inserting data to data type or some other table? --> I am inserting data into specific data types only.
Check number of db index in prod table and lower region table --> indexing on both lower and prod are same.
Issue with Commit only, not sure why in prod commit is taking longer time. I have tried multiple ways, but still I found the issue with commit only.