Sometimes when you have to import large files in a MySQL table, a good approach to speed up the execution of an INSERT statement is to temporarly disable the keys (when executing your query).
This will help MySQL to concetrate on the INSERT and not building indexes at the same time.
The basic syntax of such a sample operation is listed below:
ALTER TABLE table_name DISABLE KEYS;
LOAD DATA INFILE file_name INTO TABLE table_name
ALTER TABLE table_name ENABLE KEYS;
See More MySQL ExamplesHire Me For A Project
2024 © SofiaCoder.com