How to fastening inserting data on mysql???
I have 5000 record in excels. And I want to insert all record to mysql.. and it take time abaout 6 six minutes.. How to fastening become under 20 second to insert all 5000 records??

Peace

DODOl

Do them all in one query. Append each query to the other separating them with a semi colon. Then execute them all at once. That will dramatically increase your insert speed.

How to fastening inserting data on mysql???
I have 5000 record in excels. And I want to insert all record to mysql.. and it take time abaout 6 six minutes.. How to fastening become under 20 second to insert all 5000 records??

Peace

DODOl

Also you may want to temporarily stop using indexes on the tables in question

commented: good suggestion +7

u show ure sample query...joins are faster than subquery......the performance depends on ur query as well as your database structure....
pls show ur query and ur tables.....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.