FIX: [PostgreSQL] Update query performance in "FeedPackageVersions_MergePackageVersion"
Created:
8/22/2025 5:21:59 PM by Rich H
Status:
Open
Last pulled:
8/25/2025 8:26:26 PM
Description:
Update the update query to proper joining
```
UPDATE "FeedPackageVersionStats" FPVS_Target
SET "Download_Count" = FPVS_Target."Download_Count" + FPVS_Source."Download_Count",
"LastDownloaded_Date" = CASE WHEN FPVS_Source."LastDownloaded_Date" > FPVS_Target."LastDownloaded_Date" THEN FPVS_Source."LastDownloaded_Date" ELSE FPVS_Target."LastDownloaded_Date" END
FROM "FeedPackageVersionStats" FPVS_Source
WHERE FPVS_Target."Feed_Id" = "@Feed_Id"
AND FPVS_Target."PackageVersion_Id" = "@Target_PackageVersion_Id"
AND FPVS_Source."Feed_Id" = "@Feed_Id" AND FPVS_Source."PackageVersion_Id" = "@Source_PackageVersion_Id";
```