The coverage Profiler application might be the tool to use in your case, and try to pinpoint where your application bogs down. You can access from Tools->Coverage Profiler:
A coverage application writes information about which lines of code in a file were run. A profiler application provides information about which lines actually run, how many times a line is run, duration, and more. Coverage and profiling enable a developer to identify problem areas in an application, especially skipped code and performance bottlenecks.
Teknik,
While the coverage profiler will tell you where you are spending your time and what code to optimize, I've found that there are other things to check. A starting list:
1) Available memory on workstation when running. Depending on it's OS and what else is running, a "large" app VFP could require 128 - 512 MB.
2) Location of temp files - these should ALWAYS be on the local system, not on the network. Lots of free space and a regularly defragged system can make a huge difference.
3) Network traffic / stability - Bad NICS, hubs, switches, routers, cables can cause a lot of retries that can cripple a database application.
4) Missing or wrong indexes on the data files - too many can really slow down updates, and not enough will restrict optimization possibilities.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.