>>>LOCATE and SCAN are not optimizable anymore.
>>
>
>You can be sure that MS does not even know that these are not Rushmore anymore because they wouldn't have let this version goes online.
>
>Someone played with that technology and things have changed.
>
>Just test it. Built a 100000 records tables, do a tag on your field and LOCATE on it. To have the most do a SCAN.
I'm just looking at this thread for the first time (since you mentioned
this on the IRC yesterday).
I've got a number of tests to run, but, I'm going to run this under
FPW2.6 under WFWG3.11, VFP5 under Windows 95, and
both VFP5 and VFP3 under Windows NT 3.51 on a Windows
network. (We don't want a Novell network involved. <g>)
I probably won't get to test it fully and properly until the (U.S.)
Thanksgiving Day weekend (Nov. 28-Dec 1). But I'll give it a
shot and see how pronounced these changes are. I don't
doubt though that someone at MS has tinkered with this
inadvertently or not.
==Carl
==Carl
Carl J. WarnerVFUG OfficerThe early bird gets the worm, but the second mouse gets the cheese.