#529 - Catalogue search may be slow

Identifier #529
Issue type Minor issue (breaks specific functionality)
Title Catalogue search may be slow
Status Completed
Handling member Chris Graham
Version 8.1
Addon General / Uncategorised
Description On very large catalogues, most MySQL versions result in extremely slow query times (effectively spiking the CPU until a script timeout happens). This only happens when doing a general search, not a template search.

We used to be able to do this okay, but different MySQL versions need optimising in different ways, and to make one version work properly we ended up breaking another. Optimise for the common case and introduce a hidden value for the non-common case.

Also, introduce a lower timeout for search hooks so if something does go wrong, it doesn't hurt the server in the process.
Steps to reproduce

Funded? No
Commits

be56695
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated