Hi,
My
java application is reading data from one DB table and create CSV files and call LOAD DATA LOCAL INFILE to import into another table. This process is called inside a loop and LOAD DATA LOCAL INFILE is calling approx 50 times inside a loop in whole application.
My issue is LOAD DATA LOCAL INFILE command is very slow in starting (it took approx 10 min for few files even all CSV file size is almost same). Than this execution time is reduced to 2-3 sec for each CSV file. What is root cause for this? Is LOAD DATA LOCAL INFILE stores some information in mysql db cache and reuse it ?
Please help me how I can debug this problem.
Thanks !!