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

Quick Reply to Thread
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
"use" 1 amazon api aws bizspark breathalyzer changingprices cmg communityjournalism contentmanagement contractors copyright count court crm data database design developer development distinct drupal dui ec2 eliminate email eudora facebook form foss gartner gnu government gpl groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier journalism keyword keywords kickfire laptop law legal license licensing linux managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple mysql mysqlcolumnupdating mysqlindex mysqlinternalqueries mysqlsearch news opendatabasealliance opengovernment opensource operand oracle pdf penelope php priceupdating query referencedesign remove reorderingcolumns results resultset search select simpledb sourcecode spotify sql statement sugarcrm syntax techsupport thunderbird transparency update virtualization
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC