Skip to main content

Release v1.34.4

Released on March 2, 2026

Executive Summary​

Performance Improvements​

Billing & Database​

  • Optimized transaction count stored procedure and database index for improved query performance (151156) (PR 24086)

Overview​

This is a hotfix release containing a partial implementation of the Billing Database Write Performance Optimization feature (151156). It addresses SQL query performance issues in the transaction count procedure used for price tier calculations, eliminating an unnecessary join and optimizing the supporting non-clustered index.

Performance Improvements​

Billing Database Query Optimization​

  • Optimized sp_GetTransactionCountForPriceTier stored procedure - Removed the unnecessary LEFT JOIN to the [Billing].[Transaction] table by leveraging TransactionDate directly from the TransactionItem table. Added a soft-delete filter (DeletedOnDateUtc IS NULL) to ensure only active records are counted. This eliminates a join operation and reduces query complexity. (151156) (PR 24086)

  • Redesigned non-clustered index on TransactionItem - Replaced the existing IX_TransactionItem_TransactionDate_ContractId_PriceTierId_Covering index with a new IX_TransactionItem_ContractId_PriceTierId_TransactionDate index. The new index reorders the key columns to match the query's filter predicate order (ContractId, PriceTierId, TransactionDate), uses a filtered WHERE [DeletedOnDateUtc] IS NULL clause, and removes DeletedOnDateUtc from the key columns — resulting in more efficient index seeks for transaction count queries. (151156) (PR 24086)

Files Changed​

FileChange
billing/StoredProcedures/sp_GetTransactionCountForPriceTier.sqlRemoved Transaction table join, query directly from TransactionItem
billing/Tables/TransactionItem.sqlReplaced and reordered non-clustered index for optimal seek performance

Known Issues​

  • This release contains only a portion of the full Billing Database Write Performance Optimization feature (151156). The remaining index optimizations and code changes will be delivered in a subsequent release.