Re: How to speed UPDATES

Thanks for the solution. I put a key on the two columns and now the process is incredibly much faster.

Thanks a lot,

Etienne.

__________________________________________________

Etienne J. Orliac
Ph.D student
Institute of Engineering Surveying and Space Geodesy (IESSG)       
School of Civil Engineering
University of Nottingham
University Park
Nottingham NG7 2RD, UK

e-mail: isxejo <at> nottingham.ac.uk 

Tel   : +44 (0) 115 951 5151 & ext: 18508
Mob : +44 (0) 781 785 5496         
Fax  : +44 (0) 115 951 3881     
>>> "Ulrich Borchers" <borchers <at> megabit.net> 04/01/04 10:00 PM >>>
[snip]
>
>         my $sth = $dbh->do( "
>                               UPDATE $table
>                               SET $SET
>                               WHERE ( epoch LIKE $corep  AND station = $corsite)
>                               LIMIT 1
>                              ");