Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP5 slower than VFP3 ??
Message
From
07/07/1998 13:27:07
Dave Nantais
Light speed database solutions
Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00114759
Message ID:
00114982
Views:
27
In order to maximize the performance of any version of VFP i have found the SYS functions .. SYS(3050,1) and SYS(3050,2) invaluable ; these functions return the size of buffer memory size. SYS(3050,1) returns foreground buffer size and SYS(3050,2) returns background buffer size. The best info i have read on how to interpret and manipulate these values was in the February '97 issue of Foxtalk magazine.
"Set Turbo On: How Visual Foxpro Memory Usage Affects Performance"

You can examine the beginning of the article at Pinnacle Publishings website.
Getting a handle on the principles does take some experimental time.

http://www.newslettersonline.com/pinpub/

Unfortunately,I think Pinnacle wants $5 for you to be able to download the entire article. Even if it does not solve your particular issue using SYS(3050) can tune the performance of queries. Especially the first query that you make.

Does anyone have any other ... more "official" documentation about these SYS functions ?

Hope this helps ,
Dave.
Previous
Reply
Map
View

Click here to load this message in the networking platform