← Back to team overview

drizzle-discuss team mailing list archive

Re: [drizzle-discuss] Query Cache syntax

 

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 <difallah@xxxxxxxxx
> 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     : drizzle-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~drizzle-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References