Two things:

1) SCAN/ENDSCAN is always faster than DO WHILE NOT EOF()/SKIP/ENDDO
2) The WHERE statements are probably not optimized. You need to exactly match the index key. For information on Rushmore optimization, see the KB article on my web site.



>Can anyone spead this up! This takes 10 minutes to run on looping through 2000 records several times.
>
>
>DO WHILE !EOF()
>
> UPDATE data;
> SET data.trailer1=aud_trls.trailer;
> WHERE ALLTRIM(data.ACCOUNT)=ALLTRIM(aud_trls.ACCOUNT) AND aud_trls.max_trail=1;
> and alltrim(data.screennum)=alltrim(aud_trls.screennum);
> and alltrim(data.showtime)=alltrim(aud_trls.showtime)
>
> UPDATE data;
> SET data.trailer2=aud_trls.trailer;
> WHERE ALLTRIM(data.ACCOUNT)=ALLTRIM(aud_trls.ACCOUNT) AND aud_trls.max_trail=2;
> and alltrim(data.screennum)=alltrim(aud_trls.screennum);
> and alltrim(data.showtime)=alltrim(aud_trls.showtime)
>
> UPDATE data;
> SET data.trailer3=aud_trls.trailer;
> WHERE ALLTRIM(data.ACCOUNT)=ALLTRIM(aud_trls.ACCOUNT) AND aud_trls.max_trail=3;
> and alltrim(data.screennum)=alltrim(aud_trls.screennum);
> and alltrim(data.showtime)=alltrim(aud_trls.showtime)
>
> UPDATE data;
> SET data.trailer4=aud_trls.trailer;
> WHERE ALLTRIM(data.ACCOUNT)=ALLTRIM(aud_trls.ACCOUNT) AND aud_trls.max_trail=4;
> and alltrim(data.screennum)=alltrim(aud_trls.screennum);
> and alltrim(data.showtime)=alltrim(aud_trls.showtime)
>
> UPDATE data;
> SET data.trailer5=aud_trls.trailer;
> WHERE ALLTRIM(data.ACCOUNT)=ALLTRIM(aud_trls.ACCOUNT) AND aud_trls.max_trail=5;
> and alltrim(data.screennum)=alltrim(aud_trls.screennum);
> and alltrim(data.showtime)=alltrim(aud_trls.showtime)
>
> UPDATE data;
> SET data.trailer6=aud_trls.trailer;
> WHERE ALLTRIM(data.ACCOUNT)=ALLTRIM(aud_trls.ACCOUNT) AND aud_trls.max_trail=6;
> and alltrim(data.screennum)=alltrim(aud_trls.screennum);
> and alltrim(data.showtime)=alltrim(aud_trls.showtime)
>
> UPDATE data;
> SET data.trailer7=aud_trls.trailer;
> WHERE ALLTRIM(data.ACCOUNT)=ALLTRIM(aud_trls.ACCOUNT) AND aud_trls.max_trail=7;
> and alltrim(data.screennum)=alltrim(aud_trls.screennum);
> and alltrim(data.showtime)=alltrim(aud_trls.showtime)
>
> SKIP
>
>ENDDO
>
>
>Thanks,
>Inadvance