Since buffering and record locking cause additional work for Visual FoxPro, I guess it would be slower, not faster. You should get the fastest performance by opening the table exclusively, but that is not always practical.
You might still do speed tests, especially with table buffering (3 or 5): it might help, after all, to save all data at once.
>Just curious if I could possibly get more speed out of loading a table with memo fields by using table buffering. Since the APPEND FROM command won't load the two memo fields in my table, I have to do the following, but it's much slower, so I was wondering if any type of buffering would help. Which type (1,2,3,4,5)? How about using LOCK() or FLOCK()? Would either of these speed things up?
>
>
>fhand = FOPEN('myfile.txt')
>DO WHILE !FEOF(fhand)
> curr_line = FGETS(fhand, 8192)
> ALINES(acurr_line, curr_line, 2, '|')
> INSERT INTO (DBF()) FROM ARRAY acurr_line
>ENDDO
>FCLOSE(fhand)
>
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)