Mysql index resources for Slow Queries

by John H
~1 minute

mysqlI've got a situation where I'm dumping CSV files into a database - and doing multiple look ups before inserting the record into the database.  It is fast - but unfortunately it is still very slow.  It looks to see if an existing record is in the database with an existing email address lookup.


  • Existing email address
  • Assigns College by
    • looking up zip code
    • if it fails then look up by highschool code
  • See if email is in "Do not mail" table
  • Insert into DB

Resources on Indexing and Slow Queries