Re: way to write mysqli result set to disk

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux