Ajax search optimization high CPU load

[double]

Hello, I have a site which have comparisons of products. There's an ajax select form from this tutorial. I have ~8000 pages

The problem is high cpu load when multiple users are searching (server two 5GHz cores, 1 GB ram). I get db connection errors or very slow response time

Is there a way to optimize searching? I want to minimize db queries and make ajax responses as fast as possible

Edited October 30, 2025 by double

[zoeck]

You can have a Look a the findRaw function: https://processwire.com/api/ref/pages/find-raw/