RE: How long is my piece of string?

2002-12-23 Thread David Brodbeck
-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

RE: How long is my piece of string?

2002-12-22 Thread Iain Lang
. 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,

Re: How long is my piece of string?

2002-12-22 Thread Mark Matthews
-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

RE: How long is my piece of string?

2002-12-22 Thread Adolfo Bello
-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

Re: How long is my piece of string?

2002-12-22 Thread Mike Wexler
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

RE: How long is my piece of string?

2002-12-22 Thread Iain Lang
:[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

RE: How long is my piece of string?

2002-12-21 Thread Alan McDonald
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

Re: How long is my piece of string?

2002-12-21 Thread wcb
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

Re: How long is my piece of string?

2002-12-21 Thread Mark
- 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

Re: How long is my piece of string?

2002-12-21 Thread Mike Wexler
, 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

Re: How long is my piece of string?

2002-12-21 Thread John Hinton
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