i'd like to know if it exists a system of cache for the results of queries.
If you are willing to do this at an application level, you could calculate a MD5 for every query you plan to run and then SELECT INTO a temporary table that's based on the MD5 sum (e.g. TMP_CACHE_45123). Next time somebody runs a query, check to see if that table exists already. Then you just have to figure out some way to know when results should be expired.
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
