In the last episode (Jul 23), Greg D. said:
> I was wondering if there was anyway for me to speed up my
> update query. I wanted to index the field that i was searching for.,
> but i heard that indexing slows down updates or that some information
> might not work...is that true? thanks for any help.
>
> my update statement:
> UPDATE table SET name='NULL' WHERE email='$email'";
Everything's a tradeoff. Indexes slow down inserts and updates because
the index must be maintained, but the advantage of being able to
directly access particular records with them instead of doing a full
table scan more than offsets it. Add an index on email and be happy.
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
