Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alternate to VFP
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
MySQL
Miscellaneous
Thread ID:
01315262
Message ID:
01315299
Views:
21
Hi John,

Thanks for the suggestion. I thought of going to Stored Procedures earlier and in fact using them for small tasks.

As I mentioned in my situation, some matching happens on very large dataset (appx 30 million records). Hence we do in batches so that we can keep an eye on progress. This was the reason we bring a couple on records in VFP cursors, process, and store results. At the same time progress is monitored.

By the way thanks for the encouragement.

regards,
Abhishek
Previous
Reply
Map
View

Click here to load this message in the networking platform