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.