Slow site search results - Possible reason

[liviagouvea]

Hi @asmecher

Continuing the discussion from Slow site search results:

I found that removing the CAST in the below join could solve the problem.

@liviagouvea

JOIN issues i ON (CAST(i.issue_id AS CHAR(20)) = ps.setting_value AND i.journal_id = s.context_id)

Why is this cast for? Do you think it is possible to remove it?

Thanks in advance!

[asmecher]

Hi @liviagouvea,

That join is necessary to identify which issue a publication is assigned to – but it’s known to be a slowdown during database queries, as there is a necessary conversion of data types. This is scheduled for improvement with this issue:

https://github.com/pkp/pkp-lib/issues/10157

…which we are hoping to have fixed in OJS 3.5.0. Until then I’m afraid it’s necessary.

Regards,
Alec Smecher
Public Knowledge Project Team