Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statement takes 10x longer in app vs. vfp
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
SAMBA Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01137819
Message ID:
01138220
Views:
10
>One big difference between running the program from command line and the app is that:
When the program is run from the command line, VFP process is loaded and already running, but the application process is not runing yet. A lot of things take place when you launch your application. See what happens if open the views in a form that maybe open from a toolbar or a menu item. That way, you can compare the time more fairly between the two. And you're welcome.

Point well taken. b/c of what you wrote, i changed the menu for the app. i created a menu that has "use in view_memolist" and another that is "use view_memolist in 0". I wrapped the timing code you sent me into the menu of "use view_memolist in 0". I select the "use in" to close it, and then select the "use" to reopen the view. i then can see how long it took to use the view while the vfp engine is running in my app. (i have to close the view first as the main program opens it).

When I do the procedure in the menu within my app, i get 0.961 seconds. When I do it from within vfp8.0, i get 0.15 seconds. This i think is still a large difference between the two.

What's nice here is in trying to figure this out I have learned a few things along the way. All i need to learn now is how to solve this :-)

Paul
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform