http://www.tonyspencer.com/2004/05/27/caching-mysql-queries-mysql-cache-for-a-query/ It's Just Links Wed, 14 Sep 2011 13:47:04 +0000 http://wordpress.org/?v=2.9.1 hourly 1 http://www.tonyspencer.com/2004/05/27/caching-mysql-queries-mysql-cache-for-a-query/comment-page-1/#comment-118 Matt Fri, 14 Jul 2006 11:02:49 +0000 http://www.tonyspencer.com/2004/05/27/caching-mysql-queries-mysql-cache-for-a-query/#comment-118 Don't forget that the cache requires an absolute context match, i.e. "select * from table" and "SELECT * from table" will cause 2 separate cache entries, as will extra space characters, etc. For this reason you should either (a) be extra careful when creating queries or (b) run the query through a quick "eregi_replace" so strip out extra blank spaces and capitalise keywords not between single-quotes Don’t forget that the cache requires an absolute context match, i.e. “select * from table” and “SELECT * from table” will cause 2 separate cache entries, as will extra space characters, etc. For this reason you should either (a) be extra careful when creating queries or (b) run the query through a quick “eregi_replace” so strip out extra blank spaces and capitalise keywords not between single-quotes

]]>