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
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01182599
Message ID:
01182629
Views:
16
Hi,
Does the old minimize and maximize the form trick work.??

>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.
Regards N Mc Donald
Previous
Reply
Map
View

Click here to load this message in the networking platform