@Marcdj
@Daedalus01 is incorrect, we do support MySQL 8+. We don't yet support PHP 8.
With this being said, the slowness is probably coming from the queue counts (just a guess as I can't see exactly what's going on). If so, you can address this by going to include/class.search.php
on line 995
(roughly) and change the following:
try {
$counts = array_merge($counts, $query->values()->one());
} catch (Exception $ex) {
foreach ($queues as $q)
$counts['q'.$q->getId()] = $q->getTotal();
}
to:
// try {
// $counts = array_merge($counts, $query->values()->one());
//} catch (Exception $ex) {
foreach ($queues as $q)
$counts['q'.$q->getId()] = $q->getTotal();
//}
This will force the queues to run their own counts individually vs running a giant query of all queues at one time.
You can also try converting all of your tables to InnoDB storage engine in MySQL to improve speed.
Cheers.