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
dnelson@stripped
