Editor Dashboard loading time in OJS 3.5.0-3

[Tarcisio_Pereira]

Hello,

We recently upgraded our journal portal to OJS 3.5.0-3.
Our web server is nginx, and the database backend is PostgreSQL 17.7.

Overall, OJS feels very fast in many public-facing areas of the system. However, we are experiencing severe performance issues in some administrative sections, especially the Editor Dashboard, and the problem becomes more evident in views that list a large number of submissions.

We are currently working with a 2-minute timeout, but even so, the submission lists do not always load successfully. In many cases, the connection is terminated due to a timeout before the list finishes loading:

Are there any database-level adjustments that should be considered in this case?
For example, additional index creation, query optimization, or any specific PostgreSQL configuration that could improve performance in this particular area of the system?

I am especially interested in improvements related to submission listings and the Editor Dashboard, where performance degradation is most noticeable.

Regards,
Tarcisio Pereira

[asmecher]

Hi @Tarcisio_Pereira,

There is a similar thread here.

We’re aware that OJS/OMP/OPS 3.5.0-3 do not currently perform well with large submission lists; there have already been some improvements since 3.5.0-2, but more work needs to be done before we’ll be comfortable adding the LTS stamp to the 3.5.0-x branch.

The good news is that structurally the software is written well to perform better than previous branches. However, there is a gremlin hiding in the complex submission list code that we haven’t been able to find and evict yet.

(I’ve filed this as Improve submission list performance · Issue #12293 · pkp/pkp-lib · GitHub so you have something to watch, but was already on our radar.)

Thanks,
Alec Smecher
Public Knowledge Project Team

[hainug]

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

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

[Tarcisio_Pereira]

Hi @hainug

I even tried, but I started getting this error. Any ideia?

Regards,
Tarcisio Pereira