Unless explicitly archived or deleted, the set of price lists (PL) in a PFX instance will grow over time. Also, a PL line item can be quite a heavy object in the underlying database. Hence any search requests for PL prices within logic can get slower over time. Given that PLs generally get overriden by newer versions, the current active set of PL line item is generally not so big in comparison with the overriden ones.
On one project, in order to improve the performance of the logic, a DL job was put in place to ‘maintain’ a PA table with the current set of ‘active’ prices coming out of PLs. The benefit is that this PA table has less items than the total of all PL line items. Then the logic can call PA to get the current active price without needing to query the PLs. Another approach could be to store the active PA prices within a PP table. The goal being to no longer query the PL data directly.