MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: And yet another bug on Windows...
Posted by: Peter Zaitsev
Date: January 05, 2005 07:42PM

1) This is right. Currently MySQL does not have optimization to avoid it.

You could however add LIMIT 1 to all all limits you have which might improve their performance.

2) Right, IF is basically just a function and in MySQL Functions accept number of parameters
and return scalar value. You can execute different queries based on some data by using stored procedures in MySQL 5.0 You can also use number of IF functions to generate the row.

3) If you found a bug please report it on http://bugs.mysql.com and we'll try to fix it ASAP.
Make sure you're using latest stable version as problem might already be fixed (I remember some fixes in this area)

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.