When BC was updated from 25.0 to 25.1 I encountered massive performance issues for a simple vendor query. I found out that the reasons are the FlowFields Debit / Credit Amount incl. LCY versions on the vendor table. The only change I found in the source was, that MS added SumIndexFields definition for the fields in the Detailed Vendor Ledger Entries at Key 12.
Honestly, I do not understand why it slows down now. And what can I do in my Query?
Hi,
Yes, we’ve run into this after minor BC updates. Even small changes in FlowFields or keys can slow things down. A few things to try:
Check how the new SumIndexFields are being used.
Adjust/add secondary keys on Detailed Vendor Ledger Entries.
Limit FlowField lookups in bulk.
Run SQL/index tuning to spot bottlenecks.
We had a customer face a similar slowdown. Tuning the keys and FlowField usage worked for them, and it might work for you, too. If you’d like to discuss more, just reach me at hardik.gupta@allgrowtech.com
