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

Follow us on Identi.ca or Twitter

Username:   Password:
Create Account | About TuxRadar