I added an index for field0...with: alter table TABLENAME add index (field0);
Now those same queries run about an average of 1/10th of a sec!! My question is, is there a negative effect by indexing this field?
Obviously you woudn't index all fields...but could you?
Indexes speed searches, as you have discovered, but slow down inserts and updates, since these require that the index be updated. It's a tradeoff that you can only decide on by testing under the conditions that your app will be running under.
___/
/
__/
/
____/
Ed Leafe
http://leafe.com/
http://opentech.leafe.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
