Ok, we can look at it this way: there is a shared cache, and then a user by issuing a : *set Query_Cache enable;* is actually saying that he will use and populate the shared cache, (Fundamentally different from just disable or enable ^_^ )
For variables like expiry time, I think it's trickier, because one user A will cache a query and set the expiry time to X then the user B will be bound to this time if he execute the same query. But I can't figure any case where that would be an issue. I'll go ahead with session variable to see how it works thank you very much. ~DeD 2010/8/5 Tim Soderstrom <[email protected]> > Yes but simply enabling the cache for the session would enable the > functionality, no? How the cache actually works could be independent of > whether or not a user is actually using it? > > On Aug 5, 2010, at 3:05 PM, djellel eddine Difallah wrote: > > > Hello, > > > > Thanks for the suggestions. > > > > The cache is designed to be cross session. a use A can retrieve the > cached > > result of the same query executed by a user B. I don't know if setting > > session variables will make any sense. > > > > ~DeD > > 2010/8/5 Brian Moon <[email protected]> > > > >> On 8/5/10 2:13 PM, Tim Soderstrom wrote: > >> > >>> Well, that's my point about per-session. You can just enable the > >>> cache as part of your connection setup sequence and call it done. > >>> > >> > >> I think that is not very DBA friendly. A DBA may not have access to the > >> code and even if they could, getting changes pushed through in code in > some > >> places can be a nightmare. > >> > >> I think the the option to have it default ON with the ENABLE/DISABLE > >> commands gives everyone the most power. > >> > >> > >> -- > >> > >> Brian. > >> -------- > >> http://brian.moonspot.net/ > >> > >> _______________________________________________ > >> Mailing list: > >> https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > >> Post to : [email protected] > >> Unsubscribe : > >> https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-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
