Re: This just seems to slow

[Shawn Green (MySQL)]

On 1/3/2011 10:41, Jerry Schwartz wrote:
>> -----Original Message-----
>> From: Daevid Vincent [mailto:daevid@stripped]
>> Sent: Sunday, January 02, 2011 11:49 PM
>> ...
>
>> Also delete your INDEX / KEYs and add them at the very end instead.
>>
> [JS] Wouldn't it take as long to build the indices? I guess it probably
> wouldn't.
>

It will not. MySQL does not "grow" or "edit" its index files 
incrementally, it computes a fresh on-disk index image for every change.

Right now, you are doing a complete index rebuild for every row you add. 
If you add up the total work you are saving (index 121000 rows, index 
121001 rows, index 121002 rows,...) then you can see a big improvement 
by waiting to put the indexes on the table at the very end of the process.

http://dev.mysql.com/doc/refman/5.0/en/insert-speed.html

Yours,
-- 
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN