The14thGOD Posted January 29, 2010 Share Posted January 29, 2010 I just recently discovered this: http://dev.mysql.com/doc/refman/5.0/en/query-cache-operation.html And did some researching, it looks like its enabled by default (the settings were already what was in the configuration page: http://dev.mysql.com/doc/refman/5.0/en/query-cache-configuration.html). So is that all there is to it? I don't have to do anything with my SQL statements or php pages? It looks like there's an optional SQL_CACHE function but the setting for query_cache_type is 1. Thanks for clearing this up! Justin Quote Link to comment https://forums.phpfreaks.com/topic/190306-bluehost-query-cache/ Share on other sites More sharing options...
jskywalker Posted January 30, 2010 Share Posted January 30, 2010 you should have: have_query_cache = YES not have this: query_cache_size = 0 and there's another setting which can influence things: query_cache_limit The proper values depend a lot on what the server is doing for you Quote Link to comment https://forums.phpfreaks.com/topic/190306-bluehost-query-cache/#findComment-1004175 Share on other sites More sharing options...
fenway Posted February 1, 2010 Share Posted February 1, 2010 Assuming the QC is on, every non-deterministic query makes it way into the cache -- which isn't always a good thing. Quote Link to comment https://forums.phpfreaks.com/topic/190306-bluehost-query-cache/#findComment-1004821 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.