Hello Everyone, In my Gsoc Query Cache project, I came to a point where I need to decide on the syntax to use to either cache a query resultset or not. For reference, Mysql has a system variable "query_cache_type" that can set 3 modes: OFF : prevents caching or retrieval of cached results. ON : enables caching except of those statements that begin with SELECT SQL_NO_CACHE DEMAND : causes caching of only those statements that begin with SELECT SQL_CACHE
Since Drizzle has a different approach (multiple query cache plugins might be enabled) I'd like to check your preference on that. so any suggestion is welcome ! My ideas: 1) No system variable and just an on DEMAND kind of mode, where the developer has to specifiy SQL_CACHE to get his query cached. 2) A system variable, but no OFF mode since a plugin can be enable/disabled, but that means I need to set a default mode (ON or DEMAND). That's being said, to do that I have to modify the sql_yacc.yy, and that might not be so trivial. Thanks ~ DeD
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
