Memory issue when running code

[johnod33]

I hope this is the correct forum to use. I don't see any forum for errors.

I often run code to gather sales data month by month appending into a common dbf for many months which results in huge databases. 5 or 6 million records maybe 10 or 15 fields. Once I get the data into a common dbf I pull in data from other tables, i.e division, material codes for items ETC. Some have reached the 2 gig limit and I have had to split them up.
My question is:
Every twice in a while I get this error,
"Not enough memory for the file map"
The HELP says add more memory or stop a memory hog program.
Do you think just adding memory will help or is this a memory allocation issue?

John O'D

 

[baltman]

No, more memory will not help. Telling VFP to use less might, and/or cache clearing with SYS(1104).

See: How to speed-up your VFP Application? faq184-3504