Use MySQL workbench. Add query to the editor, execute, check results.
Then, use the "Execution plan" feature to see how things are executing and look for bad things (Cartesian products, stupid loops, etc...) See also: Query stats. Michael Munger, dCAP, MCPS, MCNPS, MBSS High Powered Help, Inc. Microsoft Certified Professional Microsoft Certified Small Business Specialist Digium Certified Asterisk Professional mich...@highpoweredhelp.com -----Original Message----- From: SSC_perl [mailto:p...@surfshopcart.com] Sent: Tuesday, April 11, 2017 4:04 PM To: mysql mailing list <mysql@lists.mysql.com> Subject: Automated SQL checker? Is there a way, perhaps with a script or a service, that one can check MySQL code to see about making it more efficient? I maintain an open source shopping cart written in Perl and it’s been awhile since the SQL has been worked on, so I want to see if it could use some updating. Thanks, Frank http://www.surfshopcart.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
