Quite slow loading after upgrade 3.1.2-4 to 3.2.0-1

Did someone is noticing slow loading of the entries in the system after the upgrade to 3.2.0?

Comparing to before it is quite visible, some pages like Submissions or “All active” take like a minute to load the entries in it.

Hi @vebaev,

How many submissions, in total, are in your system?

Regards,
Alec Smecher
Public Knowledge Project Team

About 50 active and 200 archived, before the upgrade it was very fast, like instantly!

Hi @vebaev,

Would you be able to set up the MySQL slow query log to watch for unusually expensive queries?

Regards,
Alec Smecher
Public Knowledge Project Team

Strange they told me that there is no suspicious entries in the db log.

Also noticed that User Profile - Contacts is empty and affiliation cannot be filled:

Hi @vebaev,

The slow query log is something you’d need to specifically configure/enable; it’s usually not turned on.

For the user profile link, check the PHP error log for details; failing that, check the browser’s error console.

Regards,
Alec Smecher
Public Knowledge Project Team

We have reverted the backup to 3.1.2-4 now everything back to normal speed as usual.

Hi @vebaev,

That’s understandable, but I’d like to identify/fix a bug here if possible – would you be willing to investigate this a little further?

Thanks,
Alec Smecher
Public Knowledge Project Team

Yes but keep in mind i have to forward your questions to our admins as i do not have access to systems, im just the editor of the journal :slight_smile:

Hi @vebaev,

If you’re willing to share a database dump of the 3.2.0-1 upgrade that was performing badly, I can investigate it here. If so, send me a PM.

Thanks,
Alec Smecher
Public Knowledge Project Team

I will ask our admin.

I am experiencing the same problem. And have noticed that submissions loading time has considerably increased.

Clicking on the User > Dashboard: Took 11 Seconds to load submission page
Clicking on individual submission: took 10 seconds to load the details of submission.

If you would like to investigate, I can export my sql database from phpmyadmin and send it you for investigation.
Thanks

I will watch the topic please update if any news :slight_smile:

Hi @seisense,

Yes, please PM me a copy of your database (anonymized as necessary) and I’ll see if it behaves the same here.

Regards,
Alec Smecher
Public Knowledge Project Team

Hi @asmecher,
Please guide me how to send you a PM. Sorry for my little knowledge.
Regards,

Hi @seisense,

Click on my username in this thread, and use the “Message” button. (PM is short for “private message”.)

Regards,
Alec Smecher
Public Knowledge Project Team

Hi @asmecher,
Waiting for your reply.
Thanks