Hi Seth, an example would be a query on three fields: discipline:archaeology AND location:storage NOT audit:2026 (or equivalent in the search builder). This takes about 40 seconds to process for around 143,000 results, which would be fine except that we are running through a proxy that closes the connection after 30 seconds.
Our Mysql configuration is standard, out-of-the box on Ubuntu 24.04 LTS. key_buffer_size is 16M, innodb_buffer_pool_size is 800M. We only have 2 GB of system RAM which may be the biggest bottleneck, but we don't have many concurrent users so have been able to get by, the system being fairly responsive other than with the large searches.
