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

seisense · July 24, 2020, 12:09pm

Hi @asmecher,
Its more than two months now, I sent you my database for possible investigation. Still on hold…
Thanks

asmecher · July 24, 2020, 9:18pm

Hi @seisense,

Is your database server on the same machine as your web server, or on a different host?

Regards,
Alec Smecher
Public Knowledge Project Team

seisense · July 25, 2020, 6:08am

Its on the same server.

asmecher · July 25, 2020, 2:32pm

Hi @seisense,

I loaded the database onto my development machine (a fairly normal laptop running Ubuntu) and the dashboard etc. loaded instantly. I think this must be some characteristic of your host.

Regards,
Alec Smecher
Public Knowledge Project Team

asmecher · August 4, 2020, 6:03pm

Hi all,

I wasn’t able to replicate the performance problem on my own machine, but I’ve had third-party confirmation that a slight tweak to the code resolves the problem. See Avoid index collisions if possible · pkp/pkp-lib@e659a78 · GitHub. More anecdotes from the community about whether this helped/hindered are welcome!

Regards,
Alec Smecher
Public Knowledge Project Team

seisense · August 4, 2020, 8:33pm

Finally, a sigh of relief. The proposed fix worked like a charm. Thanks @asmecher

asmecher · August 4, 2020, 9:05pm

Hi @seisense,

It was just a lucky guess about the root cause – thanks for confirming!

Regards,
Alec Smecher
Public Knowledge Project Team