Re: [PERFORM] A cache for the results of queries ?
On Thu, 26 Feb 2004, David Pradier wrote: Hi everybody, i'd like to know if it exists a system of cache for the results of queries. I believe there are some external libs that provide this at the application level. PHP's adodb is purported to do so. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PERFORM] A cache for the results of queries ?
On Thursday 26 February 2004 13:30, David Pradier wrote: Hi everybody, i'd like to know if it exists a system of cache for the results of queries. What i'd like to do : select whatever_things from (selection_in_cache) where special_conditions; The interesting thing would be to have a precalculated selection_in_cache, especially when selection_in_cache is a very long list of joins... You might want to search the archives for the -sql list for a message Materialized View Summary - some time this week. That's almost exactly what you want. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match