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
dodol
0
Newbie Poster
Recommended Answers
Jump to PostHow 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 …
All 3 Replies
stymiee
111
He's No Good To Me Dead
Team Colleague
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
882
Posting Pro
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
stymiee
commented:
good suggestion
+7
clearstatcache
0
Newbie Poster
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.