jQuery Grid Plugin - jqGrid - Topic: SQL_CACHE http://www.trirand.com/blog/?page_id=393/help/sql_cache Simple:Press Version 5.7.5.3 chridevo on SQL_CACHE http://www.trirand.com/blog/?page_id=393/help/sql_cache#p25556 Help http://www.trirand.com/blog/?page_id=393/help/sql_cache#p25556 I have some tables that are updated periodically but have many identical queries. It seems like a good case for using the MySQL cache but when I enable the cache and add SQL_CACHE to my SELECT in the grid.php it triggers an error : SQLSTATE[42000]: Syntax error or access violation: 1234 Incorrect usage/placement of 'SQL_CACHE'.

If I echo the SELECT statement and run it directly on the database it works as expected. Is there something I can do about this?

Thanks, Chris

]]> Sat, 31 Dec 2011 05:11:27 +0200