Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does buffering make a difference in speed during load?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Does buffering make a difference in speed during load?
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
SAMBA Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01064485
Message ID:
01064485
Views:
63
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)
Next
Reply
Map
View

Click here to load this message in the networking platform