I have 3 tables customers
, customer_address
and customer_org
with 20K records and I want to insert a new record
with checking 'Email'
of new record with table customers 'Email'
attribute already exist or not.
To insert 17K records it is taking 1Hr 21Min.
I'm inserting a new record in all 3 tables, if the new record Email does not exist in customers table. So is there any solution to reduce this time?
I'm using Laravel framework.
Database: mysql innodb