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

Performance drop in SQL reports in ver. 2021.1.4

5

08.12.2021

08:56

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.

Krystian Golik

08.12.2021

10:00

Krystian Golik

Hi,
I also confirm this case and for smaller 50k + reports also if there is grouping after the "assigned to" column, the loading is 10 times slower as it was before the current version 2021.1.4.84.

Solution (0)

Helpful (0)

Wrong answer (0)

Marcin Cudny

09.12.2021

22:27

Marcin Cudny

I have the same issue in ver. 2021.1.4.107, performance dropped drastically(38k items loading around 30s, with the column "assigned to" around 48s). Also, there is a problem with sorting values in filters in columns. Should be sorted alphabetically, but now it is totally random.

Solution (0)

Helpful (0)

Wrong answer (0)

Damian

20.12.2021

22:52

Damian

Dear Webcon,
do you have any ideas about speed up the report performance in newer version?

Solution (0)

Helpful (0)

Wrong answer (0)