Increase speed of inserting

Reply

Join Date: May 2007
Posts: 13
Reputation: dodol is an unknown quantity at this point 
Solved Threads: 0
dodol dodol is offline Offline
Newbie Poster

Increase speed of inserting

 
0
  #1
Jul 3rd, 2007
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
Reply With Quote Quick reply to this message  
Join Date: May 2006
Posts: 1,422
Reputation: stymiee is on a distinguished road 
Solved Threads: 35
Moderator
stymiee's Avatar
stymiee stymiee is offline Offline
He's No Good To Me Dead

Re: Increase speed of inserting

 
0
  #2
Jul 3rd, 2007
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.
John Conde
Brainyminds | Merchant Account Services | I Love Code
IT'S HERE: Merchant Accounts 101 Everything you need to know about merchant accounts!
Reply With Quote Quick reply to this message  
Join Date: Oct 2005
Posts: 523
Reputation: pty is on a distinguished road 
Solved Threads: 37
pty's Avatar
pty pty is offline Offline
Posting Pro

Re: Increase speed of inserting

 
1
  #3
Jul 7th, 2007
Originally Posted by dodol View 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
Also you may want to temporarily stop using indexes on the tables in question
Note to self... pocket cup
Reply With Quote Quick reply to this message  
Join Date: Aug 2007
Posts: 4
Reputation: clearstatcache is an unknown quantity at this point 
Solved Threads: 0
clearstatcache clearstatcache is offline Offline
Newbie Poster

Re: Increase speed of inserting

 
0
  #4
Aug 9th, 2007
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.....
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the MySQL Forum
Thread Tools Search this Thread



Tag cloud for MySQL
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC