For a big data system, one problem is the data access efficiency, one more problem is that the data insertion is very slow. We had a service system, the data loading process would take 4-5 hours. This time consuming operation is risky since if the program is interrupted during the loading process, it might be rerun, this will be troublesome. So it's necessary to improve the insertion efficiency for big data systems.Here we provide two optimization suggestions.1. Combine multiple insert statementCommon insert statement use is:INSERT INTO `insert_table` (`datetime`, `uid`,&nb...