Go to https://www.stopforumspam.com/removal and let your IP get removed from the blacklist.

Make use of Elgg's caching mechanisms + PHP opcode caching + memcache. The latter helps with caching DB queries. It does help with recurring queries. But don't expect wonders as it probably can't help with complicated queries or if someone calls page 10403 of a list that no one has recently called and is therefore not cached.

Thank you iionly.

I'll check the use of cache.

However, in this specific case the underlying data can change many times per second (depending on the number of users). Therefore, the standard approach of paging may not work here. In addition, the queries depend on many variables, including free text search. That is, there are virtually endless possibilities. Therefore, Therefore, I think the use of cache will actually be impossible.

On this page there is a suggestion for a solution based on update time ... interesting.