Performance Issues After Upgrading to OJS 3.5.0.0

Software Support
,
21

You can try this solution Fix N+1 query performance issue in Validation::getAdministrationLevel by mariuszsienkiewicz · Pull Request #12316 · pkp/pkp-lib · GitHub

lib\pkp\classes\security\Validation.php line 507, replace whereHas with withWhereHas

1 Like
22

Hi everyone.

The problem was partially resolved after that:

In my case, the loading is still slow, but it no longer times out.

1 Like
23

After applying the patch in OJS 3.5.0-3, we have seen improvement in performance. The submission dashboard now loads in approximately 0.36 seconds, which is noticeably faster than before (Approximately 1.20 minutes).

At present, our OJS 3.4 installation takes about 0.3 seconds to load the submission list.

1 Like
24

Hi @shantanusingh,

Thanks for your confirmation! We’ll make sure this gets reviewed and shipped with the next OJS 3.5.0 build.

Regards,
Alec Smecher
Public Knowledge Project Team

25

Hi @asmecher

I hope the next version OJS-3.5.0-4 will be able to load the submission list compair to OJS-3.4 (Approximately 0.3 seconds).

1 Like
26

This topic was automatically closed after 13 days. New replies are no longer allowed.