I'm no expert, but I like the simplicity of approach #1. However, I think #2 gives users more flexibility. It would be interesting to hear some users thoughts. You might try pinging Sweetums (a MySQL DBA) to get his thoughts.
On Wed, Aug 4, 2010 at 12:04 PM, djellel eddine Difallah <[email protected] > wrote: > 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 > >
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
