List:General Discussion« Previous MessageNext Message »
From:Philippe Poelvoorde Date:March 3 2005 4:55pm
Subject:Re: Switching to InnoDB turns out dissapointing
View as plain text  
Brent Baisley wrote:

> calculations from your query, like replace datesub(now(), interval 12 
> month) with a constant. Which means figuring out the right date before 
> hand.
> 

AFAIK, no column is involved in this particular function, so there's no 
point doing the computation beforehand, it's done by mysql.

-- 
Philippe Poelvoorde
COS Trading Ltd.


Thread
Switching to InnoDB turns out dissapointingAlfredo Cole2 Mar
  • Re: Switching to InnoDB turns out dissapointingGary Richardson2 Mar
    • Re: Switching to InnoDB turns out dissapointingScott Klarenbach2 Mar
    • Re: Switching to InnoDB turns out dissapointingAlfredo Cole2 Mar
      • Re: Switching to InnoDB turns out dissapointingGary Richardson2 Mar
      • Re: Switching to InnoDB turns out dissapointingJochem van Dieten2 Mar
Re: Switching to InnoDB turns out dissapointingHeikki Tuuri2 Mar
  • Re: Switching to InnoDB turns out dissapointingAlfredo Cole2 Mar
    • Re: Switching to InnoDB turns out dissapointingBrent Baisley2 Mar
      • Re: Switching to InnoDB turns out dissapointingAlfredo Cole2 Mar
        • Re: Switching to InnoDB turns out dissapointingBrent Baisley2 Mar
          • Re: Switching to InnoDB turns out dissapointingAlfredo Cole3 Mar
          • Re: Switching to InnoDB turns out dissapointingPhilippe Poelvoorde3 Mar
RE: Switching to InnoDB turns out dissapointingJon Frisby2 Mar
Re: Switching to InnoDB turns out dissapointingHeikki Tuuri2 Mar