FAQTs - Knowledge Base - View Entry - Is there a performance hit for doing the duplication check on UNIQUE keys when doing inserts?

faqts : Computers : Databases : MySQL : Language and Syntax : Performance

+ Search

Add Entry Alert

Manage Folder

Edit Entry

Add page to http://del.icio.us/

Entry

Is there a performance hit for doing the duplication check on UNIQUE keys when doing inserts?

Feb 8th, 2000 05:32
Nathan Wallace, Michael Widenius

If there doesn't already exist a duplicate key for the new row in the
table, there isn't any performance hit.