Hacking with PHP has been updated for PHP 7 - click here! >>

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)


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.