On Wed, Nov 26, 2003 at 06:44:57PM -0600, Matt W wrote:
Hi Chris,
It doesn't take MySQL any more or less time to update a unique index
than a non-unique one. :-)
Ah, a nice simple answer to a long drawn out question :) Thanks Matt,
just the reassurance I was after, I didn't want inserts to
Hello,
Let me just outline the table in question first.
I have a rather large (40,000,000 rows) table as follows:
Table: MessageIDs
Create Table: CREATE TABLE `MessageIDs` (
`mid_msgid` char(96) NOT NULL default '',
`mid_fileid` int(10) unsigned NOT NULL default '0',
`mid_segment`
Hi Chris,
It doesn't take MySQL any more or less time to update a unique index
than a non-unique one. :-)
Hope that helps.
Matt
- Original Message -
From: Chris Elsworth
Sent: Wednesday, November 26, 2003 12:14 PM
Subject: Unique Index efficiency query
Hello,
Let me just