Chris,
We have found the same thing, the more indexes you add the longer it takes
to add another index. This is because at least from what I understand is
the index/MYI file is recreated when you add another index.
I don't know enough about INNODB but based on what I do know you would do
much bet
Mike,
Thanks for the input. I also received this tip from Peter of the MySQL team.
We'll see if it works.
Chris.
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Monday, January 26, 2004 3:03 PM
To: Chris Fossenier
Cc: MySQL List
Subject: Re: Index Creation Bottle
At 12:23 PM 1/26/2004, you wrote:
We have a large database that consists of 1 table with 400 fields. I know,
the first thing you are thinking is normalize, it's not an option right now
and the database gets reloaded every 3 months. The table contains marketing
data so it is not as easy to normalize
