David Pradier wrote:
> 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.
