Increase speed of inserting

[dodol]

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

[stymiee]

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.

[pty]

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

[clearstatcache]

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.....