MySQL Forums
Forum List  »  General

Index and Unique on same column?
Posted by: Craig Matthews
Date: March 31, 2005 05:50PM

Hello,

I have a column that is a part of a composite INDEX. It has to be.

Also, the same column individually has to have a UNIQUE constraint.

When I do this, the inserts are rather slow, and phpmysqladmin shows a warning about the same column being in two indexes.

What gives? What can I do to ensure such constraints and still have fast inserts? I don't think carrying such constraint checks into the application layer is a good idea.

I'd like to be able to simply ignore this warning and find a way to improve insert performance. Thanks for any advice!

Options: ReplyQuote


Subject
Written By
Posted
Index and Unique on same column?
March 31, 2005 05:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.