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 in answering the question, which might be phrased "when might indices start making 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 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 > > > > > --------------------------------------------------------------------- > 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
