Re: [PERFORM] A cache for the results of queries ?

2004-02-26 Thread Richard Huxton
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 h

[PERFORM] A cache for the results of queries ?

2004-02-26 Thread David Pradier
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_cach

Re: [PERFORM] A cache for the results of queries ?

2004-02-26 Thread William Yu
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_4512

Re: [PERFORM] A cache for the results of queries ?

2004-02-26 Thread scott.marlowe
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