19.05.2023, 13:58 | #34 |
Участник
|
Цитата:
X++: AccountingEventSourceDocumentProcessor::executeSQL(sqlStatementText); Еще и комментарий написан X++: // Do the update as direct SQL as there is a deadlock on AccountingDistribution due to a clustered // index scan operator in the query plan. This operator appears only in low data volume scenarios. // In higher volume scenarios, the plan includes a seek operator using the index I_7452SOURCEDOCUMENTHEADERIDX. // Testing in SSMS indicates an index hint will correct the plan at low volumes and represents minimal // risk at high volumes. In order to enable the index hint on the update_recordset, direct SQL must be used. // Also note that xGlobal::randomPositiveInt32() is the method used by the kernel to populate the // recversion field.
__________________
- Может, я как-то неправильно живу?! - Отчего же? Правильно. Только зря... |
|