>>Our case is the the second from bottom. Interestingly, in your case the last case with FLOCK() was slower than without.
>>
>>In any case, my manager is certain that WITH BUFFERING = .T. caused this tremendeous slowdown. He proved this by reverting to the old version of the program, that loads data in ~1h. (The new version never finished).
>>
>>I think we need to work with my colleague on a different algorithm. I do, of course, appreciate some input on the problem from MS or from Fabio, but our experiments proved BUFFERING = .T. to be a culprit.
>
>
>What happens if you turn off TABLEVALIDATE or SET TABLEVALIDATE TO 1+4+8, just remove 2 :-) That way validation will not works during append/insert., but only when open and save records.
I don't recall all the details now, but there was a reason to put Tablevalidate = 7. I believe we consulted MS to find the best settings for us, because different settings produced some table corruptions. It was in pre SP1 days.
Anyway, it's not easy to re-run the tests. Hopefully my colleague will jump into this thread with his ideas about the problem.
If it's not broken, fix it until it is.
My Blog