I am inserting data into the table tblTextData using Insert Activity but this activity taking too much time to execute
Here, TextDT datatable is having 2 lac records and this insert activity took 10 mins to insert the data.
Can anyone explain me what might be the reason?
Today I cleared all the records in table tblTextData and ran the above insert query in local database, it took 1 min 15 secs and it inserted 2 lac records
I did the same thing in production db, cleared the table and ran the bot there it is took 9 min 54 secs and it inserted 2 lac records
In both cases the table structure and indexes, everything is same
what might be the issue here with production db?