Hi, Walter,
You're right, VFP9 is even slower. I've run this 30 times in a loop and calculated the penalty for each line. The "100.000 replacements" line in 100 tables area has the most important penalty: 55% increase.
>Fabio,
>
>I've tested this in VFP6 to VFP9 and the general conclusion is that from VFP6 on, each version seemed to get slower. I even ran a test on FPW 2.6. It was certainly slower in two tables but a hell lot faster with 100 tables.
>
>Also, from my tests, it seems that using an ID in stead of the alias is about twice as fast in VFP8 and even quicker in VFP7.
>
>Walter,
Grigore Dolghin
Class Software.