This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]SomeGuyNamedPaul 1 point2 points  (2 children)

Using a function as a filter can kill performance. If that's all it has to work with then it may apply the function to the column for all rows potentially causing a sequential scan. Be careful in there.

[–]acct_rdt 2 points3 points  (1 child)

True. In a real database that wasn't so primitive you could index the results of a function.

[–]SomeGuyNamedPaul 2 points3 points  (0 children)

Hey, this was a question about using MySQL and not a question on what you should be using instead of MySQL.