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.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to