Issue ID:
Type
Feature
Title:
Database performance improvements (locking, deadlock reduction)
Created:
2/15/2024 11:23:11 PM by Alex
Status:
Awaiting Release on 2/16/2024 4:15:44 AM
Last pulled:
2/16/2024 9:53:23 PM
Description:
This introduces two different tweaks to database code that users have reported help in reducing deadlock and other performance issues. We don't believe these should cause *worse* performance in any case, but here are the changes: * Introduce application locks to reduce deadlocks in `FeedPackageVersions_DeletePackageVersion` and `FeedPackageVersions_CreateOrUpdatePackageVersion` * Remove transactional locking from `PackageNameIds_GetOrCreatePackageNameId`, `PackageVersionIds_GetOrCreatePackageVersionId` Let us know if you would like more details on tihs one, or are closely monitoring database performance on your instance.