-Original Message-
From: Mike Wexler [mailto:[EMAIL PROTECTED]]
The best answer is, try it and see. If your tables are
small. Adding
and removing indices is very quick. And testing queries is
also very quick.
Enabling the slow query log, and enabling log-long-format can give
.
But that is my question! *When* do they provide a performance difference?
Obviously my (fairly simple) question (...and beyond what number of
records might indices provide faster extraction/presentation?... ) has not
been understood. Can anyone else help, please?
At 11:22 22/12/02 +1100,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Iain Lang wrote:
.
But that is my question! *When* do they provide a performance difference?
Obviously my (fairly simple) question (...and beyond what number of
records might indices provide faster extraction/presentation?... ) has
not been
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 22, 2002 9:44 AM
To: Iain Lang
Cc: Alan McDonald; [EMAIL PROTECTED]
Subject: Re: How long is my piece of string?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Iain Lang wrote
Iain Lang wrote:
.
But that is my question! *When* do they provide a performance
difference?
Obviously my (fairly simple) question (...and beyond what number of
records might indices provide faster extraction/presentation?... ) has
not been understood. Can anyone else help, please?
Its
:[EMAIL PROTECTED]]
Sent: Sunday, December 22, 2002 9:44 AM
To: Iain Lang
Cc: Alan McDonald; [EMAIL PROTECTED]
Subject: Re: How long is my piece of string?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Iain Lang wrote:
.
But that is my question! *When* do they provide a
performance
You need indexes as soon as (or rather just before) they provide a
performance difference.
Alan
-Original Message-
From: Iain Lang [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 22 December 2002 11:15 AM
To: [EMAIL PROTECTED]
Subject: How long is my piece of string?
.
Dear List,
I'm using
a performance difference?.
Can anyone give rules of thumb?
Cheers!
-warren
- Original Message -
From: Alan McDonald [EMAIL PROTECTED]
To: Iain Lang [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, December 21, 2002 4:22 PM
Subject: RE: How long is my piece of string?
You need
- Original Message -
From: wcb [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Sunday, December 22, 2002 2:23 AM
Subject: Re: How long is my piece of string?
Hi!
I was interested in the answer to this person's question, too!
The following response:
You need indexes as soon
, December 22, 2002 2:23 AM
Subject: Re: How long is my piece of string?
Hi!
I was interested in the answer to this person's question, too!
The following response:
You need indexes as soon as (or rather just before) they provide
a performance difference.
Alan
seems to lack detail
wcb wrote:
seems to lack detail in answering the question, which might be phrased when
might indices start making a performance difference?.
newbie to indexing talk
Well, I'm no wizard or anything, but have just spent the last twos days
on this subject here on my project. Anyway, waht I have
11 matches
Mail list logo