I'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.
Lookups
- 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
