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
Hi.
On Tue 2002-07-23 at 08:35:29 -0700, [EMAIL PROTECTED] wrote:
> 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
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
Hello Greg,
maybe it can be of some help:
- Try ( if memory is not a problem ) to read the entire file in memory,
inside an array, and use foreach() in the array. It is quicker than
reading line by line from the HD;
- And you may try to mount your U
I'm a bit confused by what you mean here; are you just updating the
'ktjnews' column, or are you attempting to reset the 'email' column as well?
(The source says the first, your comments suggest the second.)
Further, exactly which part of this is too slow? Obviously, each query will
require scann
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 upda
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 the
> email field. The problem is that it takes t
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 t