Hi all,
If anyone is able to try creating an index that may resolve the issue, please have a look at Performance issue using LIMIT and OFFSET in search users query · Issue #5288 · pkp/pkp-lib · GitHub – your confirmation would be helpful!
Thanks,
Alec Smecher
Public Knowledge Project Team