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)

 

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.