From: Rick James
Date: February 5 2013 5:06pm
Subject: RE: IF and CASE
List-Archive: http://lists.mysql.com/mysql/228932
Message-Id: <582AFBFC517D194489EF570FE21694CF1360CAF5@GQ1-EX10-MB03.y.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

As a Rule of Thumb, function evaluation time is not significant to the over=
all time for running a query.  (I see IF and CASE as 'functions' for this d=
iscussion.)

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
>=20
> It is my impression that when their functions are equivalent, IF takes
> more time than CASE. Comment?
>=20
> Do they always evaluate all their arguments?
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql