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)