>>I'm still using VFP8 here, take this into account. Perhaps, in VFP9 filtered indexes are Rushmore optimizable.
>
>On this ( SEEK + SCAN WHILE ) code , every optimization is out of the game.
>
>Nadya,
>
>INDEX conditions1 FOR conditon2
>
>with
>SET ORDER
>SEEK condition1
>SCAN WHILE condition1
>
>
>is the faster possible code into VFP with:
>- with TALK OFF
>- table/index cached.
>
>When you do intensive read/updated, cache operations can change timing results randomly.
>
>Try to decrease/increase the SYS(3050,1) value.
Thanks. I was so disappointed of the performance, that I already switched to SCAN FOR without order set.
If it's not broken, fix it until it is.
My Blog