Home > Forum > General > Performance drop in SQL reports in ver. 2021.1.4

Performance drop in SQL reports in ver. 2021.1.4
5

MVP

Hi,
After upgrading from 2021.1.3.205 to ver. 2021.1.4.84, I can see a very big performance drop for reports that have more than 250k items. Very often they don't even load at all. All indexes and sql statistics are rebuilt. After verification, I found the reason, it is the column 'assigned to'. After removing this column from the report, all large reports are loaded almost immediately (even those with many calculated columns).
It looks like in this version the query has been changed to the WFElementTasks array?

I am curious if someone will confirm this scenario?

Regards.

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings