Syphon Posted April 18, 2008 Share Posted April 18, 2008 When MySQL parses a query, does it convert all the syntax to uppercase or lowercase? I know that it converts table names to lower case (if the option is turned on) when they're created, but does it do the same thing for queries? Thanks in advance. Quote Link to comment Share on other sites More sharing options...
fenway Posted April 18, 2008 Share Posted April 18, 2008 Why do you ask? The keywords are not case-sensitive... Quote Link to comment Share on other sites More sharing options...
Syphon Posted April 18, 2008 Author Share Posted April 18, 2008 For the sake of argument lets say MySQL does convert all of the keywords to lowercase. Would a query with all lowercase keywords theoretically execute faster because no conversion would be needed? I don't think you'd see much of a performance gain, but I just like to know that my queries are running as fast as possible. Quote Link to comment Share on other sites More sharing options...
fenway Posted April 18, 2008 Share Posted April 18, 2008 For the sake of argument lets say MySQL does convert all of the keywords to lowercase. Would a query with all lowercase keywords theoretically execute faster because no conversion would be needed? I don't think you'd see much of a performance gain, but I just like to know that my queries are running as fast as possible. Not even theoretically, since it would do the conversion regardless. Quote Link to comment Share on other sites More sharing options...
Syphon Posted April 18, 2008 Author Share Posted April 18, 2008 Cool, thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.