Serious performance issue with regards to caching - OJS 3

asmecher · January 9, 2023, 8:01pm

OK, that looks as it should, thanks.

Looking at your list above, I see:

138139 	Execute 	147 	Creating sort index 	SELECT a.*, ug.show_title, s.locale, COALESCE(agl.setting_value, agpl.setting_value) AS author_g

This is related to the author index, which is legacy code and is known to perform poorly. (It will be removed entirely starting with 3.4.0.) See this related issue:

github.com/pkp/pkp-lib

googleSearch report a lot of slowpages linking to author's search

opened 05:41PM - 12 Jul 21 UTC

closed 12:29AM - 16 Oct 21 UTC

marcbria

Housekeeping:1:Todo

**Describe the bug** I'm not able to tell you where, but looks like somewhere i…n OJS 3.2.1 (stable) the application builds a link to the searcher with a reference to the author as follows: https://revistes.uab.cat/enrahonar/search/authors/view?firstName=Josep&middleName=M%C2%AA&lastName=Quintana%20Cabanas&affiliation=&country= This search takes tooo long to be resolved and google Search counts those urls as an error. The search returns values that, at fist glace, don't make any sense to me. Do you know where is this referenced? Is this something important to keep? **To Reproduce** Steps to reproduce the behavior: 1. Go to https://revistes.uab.cat/enrahonar/search/authors/view?firstName=Josep&middleName=M%C2%AA&lastName=Quintana%20Cabanas&affiliation=&country= 2. See error (long time to resolve) **What application are you using?** OJS stable-3.2.1 from docker images (packaged last week). **Additional information** This is the error 5xx increment that google Search reports after moving from 2.x to 3.x: ![imagen](https://user-images.githubusercontent.com/2779168/125251923-1b235800-e2f8-11eb-81a9-7e44895773c9.png) The error could be related with this: https://forum.pkp.sfu.ca/t/ojs-3-0-2-search-filters/30766/14 As a workaround you can remove this path from your robots... even they will be still exposed in your sitemap. If this feature is not working fine, I would encourage to disable it till it's fixed.

If you see a lot of requests for /search/authors (e.g. from search engines) in your access log around the time that performance degrades, it’s likely related to this. There is a suggestion here on how to quickly disable it.

Regards,
Alec Smecher
Public Knowledge Project Team