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