Iain Lang wrote:
.Its not that it hasn't been understood. Its not a simple question. It depends on a lot of things you didn't bring up. What is the ration of reads to writes? What is the key of values? What do the queries look like? What hardware are you running on?
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?
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.
At 11:22 22/12/02 +1100, Alan McDonald wrote: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 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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-----------------------------------------------------------------------------
"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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
