On Sat, 2005-01-22 at 11:50 -0500, Luc Vandal wrote:
> Perhaps Iâm not doing things correctly, but this code will take about 1
> minute to execute (2400 records on a total of around 44000 records):
>
> for(INT nCurrRow=1;nCurrRow<=nRows;nCurrRow++)
> {
> strQuery.Format( "UPDATE something SET
> thatThing = 0, otherthing = %f WHERE stuff = %d AND hello = %d AND bye =
> -1", â );
>
> }
>
What indices do you have on the SOMETHING table? You're
going to want one to prevent your code from running in
time O(n**2).
