Slowness in updating account records in prod

MarkMpn / Sql4Cds

SQL 4 CDS core engine and XrmToolbox tool

MIT License

74 stars 22 forks source link

Slowness in updating account records in prod #456

Closed Soundar1008 closed 4 months ago

Soundar1008 commented 4 months ago

**** i am executing same query SQL4CDS in prod & ua ENV To update 10k records in uat it is taking 1 minute Where as in prod it is taking 10 mins

Need to update 5M ACCOUNT record

MarkMpn commented 4 months ago

This doesn't sound like a SQL 4 CDS issue - if you've got a difference between different environments I'd look at anything else that's different such as plugins or flows that might be slowing things down.