List:General Discussion« Previous MessageNext Message »
From:Alan McDonald Date:December 22 2002 12:22am
Subject:RE: How long is my piece of string?
View as plain text  
You need indexes as soon as (or rather just before) they provide a
performance difference.

Alan

-----Original Message-----
From: Iain Lang [mailto:iainlang@stripped]
Sent: Sunday, 22 December 2002 11:15 AM
To: mysql@stripped
Subject: How long is my piece of string?


.
Dear List,

I'm using php & MySQL for a cycling club website, results, guest-book,
events and so on.  I've just started and have faithfully created indices
all over the place.

At present, we have less than 400 records, be they of members, of image
URLs, whatever.  Each year will, I expect, create an additional 400 records.

Am I gilding the lily adding indices for such a small database?  Does such
a small database really *need* indices, and beyond what number of records
might indices provide faster extraction/presentation?

I realise how vague a question it is, hence the subject title.

Yooors,

Iain.


----------------------------------------------------------------------------
-
"Most progress has been the result of the
  actions of unreasonable men."   G.B.Shaw.
http://www.johnstone-wheelers.co.uk
      Johnstone-Wheelers - the friendliest
           cycling club in Scotland!



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread128202@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-alan=meta.com.au@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Thread
How long is my piece of string?Iain Lang22 Dec
  • RE: How long is my piece of string?Alan McDonald22 Dec
    • Re: How long is my piece of string?wcb22 Dec
    • Re: How long is my piece of string?Mark22 Dec
      • Re: How long is my piece of string?Mike Wexler22 Dec
    • Re: How long is my piece of string?John Hinton22 Dec
    • RE: How long is my piece of string?Iain Lang22 Dec
      • Re: How long is my piece of string?Mark Matthews22 Dec
        • RE: How long is my piece of string?Adolfo Bello22 Dec
          • RE: How long is my piece of string?Iain Lang22 Dec
      • Re: How long is my piece of string?Mike Wexler22 Dec
RE: How long is my piece of string?David Brodbeck23 Dec