List:General Discussion« Previous MessageNext Message »
From:Rick James Date:February 5 2013 5:06pm
Subject:RE: IF and CASE
View as plain text  
As a Rule of Thumb, function evaluation time is not significant to the overall time for
running a query.  (I see IF and CASE as 'functions' for this discussion.)

Do you have evidence that says that IF is slower?  Perhaps using BENCHMARK()?



> -----Original Message-----
> From: hsv@stripped [mailto:hsv@stripped]
> Sent: Monday, February 04, 2013 11:31 PM
> To: mysql@stripped
> Subject: IF and CASE
> 
> It is my impression that when their functions are equivalent, IF takes
> more time than CASE. Comment?
> 
> Do they always evaluate all their arguments?
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql

Thread
IF and CASEhsv5 Feb
  • RE: IF and CASERick James5 Feb
    • RE: IF and CASEhsv5 Feb