----- Original Message ----- > From: "Kevin Falcone" <falc...@bestpractical.com>
> This destroys mysql's query cache, which is a very nice performance > win. On some reflection, I have a question: which part of my suggestion destroys the utility of the cache? That there's another clause in the query? Or that it involves "Today's Date"? Cause the former would only seem to apply between uses of the same exact query in different places in the code... and the latter could be solved by simply making the tagged-on clause be 'Tag-string' = 'Tag-string', I *think*. But I am only an egg in these things... Cheers, -- jra -- Jay R. Ashworth Baylink j...@baylink.com Designer The Things I Think RFC 2100 Ashworth & Associates http://baylink.pitas.com 2000 Land Rover DII St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274 -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 & 27, 2011 * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011