943,772 Members | Top Members by Rank

Web Development > Databases > MySQL > Increase speed of inserting
Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 2243
  • MySQL RSS
Permalink
Jul 3rd, 2007
0

Increase speed of inserting

Expand Post »
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
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dodol is offline Offline
13 posts
since May 2007
Permalink
Jul 3rd, 2007
0

Re: Increase speed of inserting

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.
Moderator
Reputation Points: 161
Solved Threads: 38
He's No Good To Me Dead
stymiee is offline Offline
1,422 posts
since May 2006
Permalink
Jul 7th, 2007
1

Re: Increase speed of inserting

Click to Expand / Collapse  Quote originally posted by 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
Also you may want to temporarily stop using indexes on the tables in question
pty
Reputation Points: 64
Solved Threads: 39
Posting Pro
pty is offline Offline
530 posts
since Oct 2005
Permalink
Aug 9th, 2007
0

Re: Increase speed of inserting

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.....
Reputation Points: 10
Solved Threads: 0
Newbie Poster
clearstatcache is offline Offline
4 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: MySql 5.0 Developer Certification
Next Thread in MySQL Forum Timeline: multiple select issue





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC