Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Low level read-write optimization for very big file
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00733923
Message ID:
00733953
Views:
15
>You can comment out writing to the file and run your program to see if it'll slow down. It'll tell you if reading or writing is responsible.
>

Of course :-)
Thanks


>>>Maybe the problem is too much memory, so Windows start swaping VFP memory. Try to limit the memory with SYS(3050). You can also try to issue FFLUSH() comman every few thousand records.
>>>
>>
>>I have allready try to fflush at every 10 000 rows with no benefits.
>>
>>I do not know that there is such thing as "too much memory" :-)
>>In my mind the more you can put in a box, better the performance will be!
>>Tomorrow, I will try to reduce the fox memory to see what happen...
>>
>>Thanks :-)
>>
>>
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...


Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca
Previous
Reply
Map
View

Click here to load this message in the networking platform