Thanks. I've read the manual. I guess I was looking for a more direct explanation to make sure I had it clear and to learn any tips that might be useful that wouldn't be in the manual. As my database will be quite large I'm worried about effective optimizations.
> http://www.mysql.com/doc/C/R/CREATE_INDEX.html > http://www.mysql.com/doc/M/y/MySQL_indexes.html > > Can anyone give me some tips on how indexes work? > > > > I noticed that UNIQUE() seems to create a lock on all given fields per > > call like UNIQUE (md5, mime) so that no row can have the same combination > > of md5 and mime type which is good but assuming I wanted to have each > > unique on it's own I'd need UNIQUE (md5), UNIQUE (path) right? > > > > Are INDEX's the same as KEY's? When I INDEX() something it seems to dump > > as a KEY(). Does it matter if you INDEX ( path, md5, mime ) or > > INDEX(path), INDEX(md5), INDEX(mime)? They seem to look different in the > > db depending how I do it but both seem to run at about the same speed even > > over a large db. Either is a huge speed increase over the original that > > had only primary keys it seems. > > > > Right now in a db with several tables.. some with hundreds of thousands of > > rows.. the average query time seems to be about half a second to a second > > on a P133. Is that good, bad, or normal? > > > > *^*^*^* > > Michael McGlothlin <[EMAIL PROTECTED]> > > http://mlug.missouri.edu/~mogmios/projects/ > > > > > > --------------------------------------------------------------------- > > 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
