>Change this line
>

> 	replace f2 WITH f2+1 FOR BETWEEN(foo.f1,m.low,m.high) IN foo
>

>with this
>

>SELECT Foo
>SEEK m.Low
>REPLACE f2 WITH f2 + 1 WHILE BETWEEN(f1, m.low, m.high)
>

>
>
>>hi,
>>here is the code which i want to speed up....
>>any ideas ?? or a different approach ??? VFP 6
>>
>>

>>lparameter ncount
>>local ncount
>>
>>if !used('foo')
>>	CREATE CURSOR foo (f1 n(20,2),f2 i)
>>else
>>	select foo
>>	zap
>>endif
>>
>>FOR m.xi = this.highlow1.ymin TO this.highlow1.ymax STEP (ROUND((this.highlow1.ymin+this.highlow1.ymax)/2,0)*0.1)/100
>>	INSERT INTO foo (f1) values(m.xi)
>>NEXT
>>SELECT foo
>>INDEX ON f1 TAG f1
>>
>>
>>SELECT (this.alias_name)
>>GOTO ncount
>>SCAN NEXT 80
>>	m.high = high
>>	m.low = low
>>*	replace f2 WITH f2+1 FOR foo.f1 >= m.low and foo.f1 <= m.high IN foo
>> 	replace f2 WITH f2+1 FOR BETWEEN(foo.f1,m.low,m.high) IN foo
>>ENDSCAN
>>

>>how can use the index in the above ?
>>
>>
>>suhashegde


hi,
good idea,
position on the first found record and then replace saved me a average of 0.07sec in total of 4700 hits

still looking to speed up a bit more , any more ideas ??
thanx
suhas