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. Link to comment https://forums.phpfreaks.com/topic/101708-solved-mysql-query-execution/ 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... Link to comment https://forums.phpfreaks.com/topic/101708-solved-mysql-query-execution/#findComment-520376 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. Link to comment https://forums.phpfreaks.com/topic/101708-solved-mysql-query-execution/#findComment-520388 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. Link to comment https://forums.phpfreaks.com/topic/101708-solved-mysql-query-execution/#findComment-520396 Share on other sites More sharing options...
Syphon Posted April 18, 2008 Author Share Posted April 18, 2008 Cool, thanks. Link to comment https://forums.phpfreaks.com/topic/101708-solved-mysql-query-execution/#findComment-520418 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.