List:General Discussion« Previous MessageNext Message »
From:Morten Primdahl Date:March 4 2009 7:42pm
Subject:Re: SQL_NO_CACHE
View as plain text  
On Mar 4, 2009, at 8:38 PM, Jocelyn Fournier wrote:

> Just curious : if there's no index on the column why don't you try  
> to add one ? That's probably why it takes a lot of time on the  
> production machine.

Hehe.. I can understand why you ask, I over simplified the question  
which was wrong of me. I'm just using this specific column because I  
was playing around while trying to figure out why the first query was  
slow and the subsequent snappy.

Br,

Morten


Thread
SQL_NO_CACHEMorten4 Mar
  • Re: SQL_NO_CACHEMicah Stevens4 Mar
  • Re: SQL_NO_CACHEPerrin Harkins4 Mar
  • Re: SQL_NO_CACHEThomas Spahni4 Mar
    • Re: SQL_NO_CACHEPerrin Harkins4 Mar
      • Re: SQL_NO_CACHEjocelyn fournier4 Mar
        • Re: SQL_NO_CACHEMorten Primdahl4 Mar
          • Re: SQL_NO_CACHEjocelyn fournier4 Mar
            • Re: SQL_NO_CACHEMicah4 Mar
          • Re: SQL_NO_CACHEJocelyn Fournier4 Mar
            • Re: SQL_NO_CACHEMorten Primdahl4 Mar
              • Re: SQL_NO_CACHEJohan De Meersman4 Mar