Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP slowdown after processing large amounts of data
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
VFP slowdown after processing large amounts of data
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01182599
Message ID:
01182599
Views:
136
I've noticed for quite awhile that VFP will slow down after I perform a task that processes large amounts of data. I'm not sure if it has just eaten up a bunch of memory and slows down until Windows determines the memory has been released and then does its garbage collection chores or what, but I was just wondering if other people see this. An example is something I just did for a client. A form takes twelve tables and consolidates the data into 4 tables. The amount of data processed is about 83 MB. I have to open the 12 tables and the four they will be consolidated to. I'm selecting into a cursor and then appending from that to the appropriate consolidation table. I use the same cursor name each time, so it's not as if I'm leaving 12 big old cursors sitting out there. Anyway, when I go to close the form it takes a moment or two. Maybe 5 to 8 seconds, whereas if I just open the form (which opens the 12 source tables and the four target tables) and then immediately close it, it closes right away. So it's only if the consolidation code runs and all the data gets processed that I get the slow response. As mentioned, I generally see this when I've done some task that processes a lot of data (in the IDE or in a program). Sometimes I have to exit VFP and restart it, but I haven't really tracked the statistics on this. Like I said, I assume a bunch of resources were eaten up and it takes a bit to get back to normal.
eCost.com continues to rip people off
Check their rating at ResellerRatings.com
Next
Reply
Map
View

Click here to load this message in the networking platform