RE: IF and CASE

2013-02-05 Thread hsv
>>>> 2013/02/05 17:06 +, Rick James >>>> 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 i

RE: IF and CASE

2013-02-05 Thread Rick James
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- > Fro

IF and CASE

2013-02-05 Thread hsv
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