How to set up modx cache and optimize page load speed for a large site?

Question

MODX

There is a site on modx revo with 40,000 pages. There is a category page where these pages are displayed using pdoPage, 20 pieces on each pagination page.
Also on the category page there is an ajax filter, when changed, a selection is made from the database with a request of this type:
name LIKE '.'"%'.$_GET['name'].'%"
Here is the page load data:
time spent on database requests: 3.0324 s
number of database requests: 402
time spent on PHP scripts: 0.9764 s
total time spent on page generation: 4.0088 s
content source (database or cache): database
Tell me how you can optimize database queries and properly configure caching.

Answer 1

Why so many requests? Show how you call the snippet. Have you tried using a hair dryer?