Use shorter queries where possible

"DELETE FROM usertable;" is much (much!) faster than "DELETE FROM usertable WHERE Name LIKE '%';" simply because MySQL actually sits and compares each name to % (remember that a percent sign (%) means "anything, so MySQL matches all names)


Want to learn PHP 7?

Hacking with PHP has been fully updated for PHP 7, and is now available as a downloadable PDF. Get over 1200 pages of hands-on PHP learning today!

If this was helpful, please take a moment to tell others about Hacking with PHP by tweeting about it!

Next chapter: Use the EXPLAIN statement >>

Previous chapter: Select as little data as possible

Jump to:


Home: Table of Contents

Copyright ©2015 Paul Hudson. Follow me: @twostraws.