Forums / Developer / Disable cache for raw SQL query

Disable cache for raw SQL query

Previous topic

Developer

Next topic

Author	Message
Scott Foster	Wednesday 16 February 2011 9:42:44 am I'm trying to run a raw sql query and have it not be cached. When I run the following $db = eZDB::instance( ); $query = 'select * from table'; $data = $db->arrayQuery( $query ); print_r ( $data ); It returns the results the first time, but not the second, third, etc time. I'm assuming ez publish caches those results somewhere. Is there anyway to disable cache just for a particular query?
André R.	Thursday 17 February 2011 10:17:32 am My guess is that the code above is inside a template operator or similar which is called inside a template that is cached in view cache or cache-block. You can disable both using site.ini settings for development, but for prod you should never disable cache unless you have a very low traffic site and you don't care about its performance, and green house gases.. :) eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom

Author

Message

Scott Foster

Wednesday 16 February 2011 9:42:44 am

I'm trying to run a raw sql query and have it not be cached. When I run the following

$db = eZDB::instance( );
$query = 'select * from table';
$data = $db->arrayQuery( $query ); 
print_r ( $data );

It returns the results the first time, but not the second, third, etc time. I'm assuming ez publish caches those results somewhere. Is there anyway to disable cache just for a particular query?

André R.

Thursday 17 February 2011 10:17:32 am

My guess is that the code above is inside a template operator or similar which is called inside a template that is cached in view cache or cache-block.

You can disable both using site.ini settings for development, but for prod you should never disable cache unless you have a very low traffic site and you don't care about its performance, and green house gases.. :)

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom