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
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
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 …
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
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.....
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.