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 learned is they make a performance difference immediately, but that can be increases or decreases in performance. The basic rules I have laid out for myself include, only build an index if you 'are' going to be sure you write the SQL to make use of it. This is an area where I'm struggling, but have made a break thru or two. Only index fields with lots of the same data. If every piece of data is different, the index gets to be about as convoluted as the field itself. Indexes slow down writes and updates to the database and take up disk space, so indexing every field in your database is generally not a good idea. I think I read something about mysql getting a bit confused about how best to use the indices if you have lots of them... so, again, carefully create the ones that 'will' for sure be used, and are in a field of like data. In my earlier post regarding the success on my date index stuff, I think the only way the index would be used is if in the WHERE statement, the indexed field was the first to display? and also, maybe it could not be used inside of a function? </newbie to indexing talk> So, here I am a newbie to indices talking about something I know little about... Hopefully someone will read this post and correct anything that is in error... So, I'll learn if I've made any errors in my thinking? -- John Hinton - Goshen, VA. http://www.ew3d.com Those who dance are considered insane by those who can't hear the music.... --------------------------------------------------------------------- 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
