Re: using limit and also getting total count

[Michael Widenius]

>>>>> "Jay" == Jay J <3pound@stripped> writes:

<cut>

Jay> Question: Has there been any discussion about cacheing the answers to
Jay> queries? If I understand correctly something like the 'key_buffer' is shared
Jay> amongst the threads, keys .. but not answers. (right?)

Jay> So in the example above, maybe he is forced to run a count(*) which returns
Jay> 6, but if none of the tables have changed in the interim then next time the
Jay> cached answer is returned? (I realize this isn't a new concept)

Jay> -Jay

Hi!

A MySQL users is working on caching query results (The MySQL 
3.23.4 server already has some hooks for this).  I don't however know
when he gets the time to finish it.

Regards,
Monty