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:
01138230
Views:
11
>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

I'm glad that you learned stuff. That's why I hang around here too. Sharing is power.

You'll probably find something because you know all the details of your code and data.

Good luck!
Dawa Tsering


"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."

- Ephesians 4:29-30 NIV

Dare to Question -- Care to Answer

Time is like water in a sponge, as long as you are willing you can always squeeze some.

--Lu Xun, Father of Modern Chinese Literature

Previous
Next
Reply
Map
View

Click here to load this message in the networking platform