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:
01138213
Views:
11
>here are the results. the first line after the program line is the time it took to run from within vfp8.0 (ie issuing "do p_main" in the command window). then i uncommented the "read events" line, rebuilt the app, and ran my application from the desktop. The 2nd times listed is the results from running the app from the desktop icon.
>
>zoom window screen maz
>0.00000000
>0.30000000
>open database d_tasks
>0.00000000
>0.11000000
>use view_tasklist in 0
>0.15000000
>0.80100000
>use view_memolist in 0
>0.12000000
>1.05200000
>use \\linux\project\patient alias patient in 0
>0.57100000
>0.22000000
>do menu1.mpr
>0.01000000
>0.23100000
>
>
>As you can see, the view_memolist line is almost 10x slower in my app (1.052) vs when run from within vfp8.0. The view_tasklist also is much slower, but not 10x.
>
>Any ideas what could be happening here? BTW, thanks for the program. That will come in handy in the future as well for diagnostics.
>
>Paul

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.
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