List:General Discussion« Previous MessageNext Message »
From:Scott Noyes Date:November 9 2005 8:50pm
Subject:Re: MySQL insert performance
View as plain text  
> How long should it take to insert approx 30,000 rows into MySQL.

Depends on the data and field structure.  Do you have lots of indexes
on the table?

>It takes me about 30 mins.

There are some tips at http://dev.mysql.com/doc/refman/4.1/en/insert-speed.html

--
Scott Noyes
snoyes@stripped
Thread
• MySQL insert performanceDhiren Bhatia9 Nov
  • Re: MySQL insert performanceScott Noyes9 Nov
  • Re: MySQL insert performanceBrent Baisley9 Nov
  • Re: MySQL insert performanceGleb Paharenko9 Nov
    • Re: MySQL insert performanceDhiren Bhatia10 Nov
      • Re: MySQL insert performanceDhiren Bhatia11 Nov
        • Re: MySQL insert performanceMatthew Lenz11 Nov
      • Re: MySQL insert performanceGleb Paharenko12 Nov