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
Hi all
I am new to MySql and I am thinking about using it for managing a
database, which would have a approximated length of 500 Mb. It is formed
of vectors.
Trouble is that I am worried about the ability of MySql to handle that
amount of data.
Do you know about any article or study about
On Mon, 14 Oct 2002, Alberto Ruiz Cristina wrote:
Hi all
I am new to MySql and I am thinking about using it for managing a
database, which would have a approximated length of 500 Mb. It is formed
of vectors.
Trouble is that I am worried about the ability of MySql to handle that
amount of
At Montag, 14. Oktober 2002 14:57 Alberto Ruiz Cristina wrote:
Hi all
I am new to MySql and I am thinking about using it for managing a
database, which would have a approximated length of 500 Mb. It is formed
of vectors.
Greetingz,
from my experiences with several Databases since the
[EMAIL PROTECTED]
Sent: Monday, October 14, 2002 6:27 PM
Subject: Efficiency Query
Hi all
I am new to MySql and I am thinking about using it for managing a
database, which would have a approximated length of 500 Mb. It is formed
of vectors.
Trouble is that I am worried about the ability