[thelist] Updating a BIG table with a few indexes...

[Matt Warden]

On 9/5/07, Tris <beertastic at gmail.com> wrote:
> ALTER TABLE table1 ADD INDEX (fieldName), ADDINDEX (fieldName) .........
>
> with 8 million records...

Try CREATE INDEX syntax instead, or at least try separate alters. Only
thing I can think of is that you are running into I/O issues, or your
database size is growing so fast that it must  pause to allocate new
space, which will take time each time. Still, though, it should never
take 9+ hours. 8 million records should be a piece of cake. 1 hr tops.

-- 
Matt Warden
Cincinnati, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.