The following are five ways to improve queries involving table inserts: 1) use LOAD DATA INFILE when loading data from a text file