faster update

2002-07-23 Thread Greg D .
Hello, 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

faster update

2002-06-06 Thread Greg D .
Hello, I was wondering if there was a better way to speed up my update statement in my perl script. It goes through all the entries in the database , which is around 800, 000, and then updates the email field. The problem is that it takes to long. thanks in advance for any help here

Re: faster update

2002-06-06 Thread Greg D .
On Thursday 06 June 2002 08:53 am, you wrote: On Thursday 06 June 2002 9:51 am, Greg D. wrote: I was wondering if there was a better way to speed up my update statement in my perl script. It goes through all the entries in the database , which is around 800, 000, and then updates