I have mysql database and I want to insert about 40’000 rows into it from PHP code , but my code takes more than 15 minutes to insert the rows, is there any chances to optimize it? where is my problem(PHP code / database design) ? here are the details: – the row data are stored in a utf-8 txt