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