Re: way to write mysqli result set to disk

On Wed, Jan 25, 2006 at 05:22:35PM -0800, jonathan wrote: > hmm.... is this a mysql 5 feature. could be interesting but haven't > heard much about it. No, the link i gave just does a redirect to the current stable release documentation, mysql has docs for the major releases and what each one supports. I know for sure that 4.1 supports sql_cache, 4.0 mabey. In summary suppose you have a query: select SQL_CACHE * from table where name like '%foo%' And considering the first query will take about .50 seconds to execute, the next query that matches that takes about .0001 seconds. The Query Cache can get complicated be sure to read all the docs on it. Curt. -- cat .signature: No such file or directory