Forum
05:11
30/12/2010
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
Most Users Ever Online: 715
Currently Online:
32 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66