I have a system that holds more than 2000 clients and it keeps growing, and every time they do a search, they call mysql with more than 20,000 items (and that number also keeps increasing), would it be possible for me to have one cache or do something for it does not need to fetch forever?
I was thinking of making a system that the most searched word creates a file on the server with the first 20.30 searches, would it?
It is interesting to use Elastic Search or Solar for indexing searched words.
They allow you to generate a key indexing that works as a cache, so you search for large amounts of textual data.
Another type of cache is data query caching.
You identify the querys that are most frequently performed and save the cached results for a period. In parameterized queries, you can generate a hash based on these parameters and prefix the cache key combined with the hash.
Some ideal tools for this are Redis, Memcached, APC, etc ...
