>I have an app that does thousands of calculations. I would like to see it run faster. Does anyone have any speedup tips to pass along to the VFP community?
>
>And . . . Does a class execute any quicker than a prg?
As Vladimir said DLL, FLL, indepandant C,C# exes, winAPI... might be needed.
Use m. (MDOT) - most important optimization maybe. Failure to do so will be punished to the possible extent:)
If parts of calculations could be done independantly then spawn extra processes doing calculation in background.
If there are out-of-the-box applications that can do it, utilize them (ie: excel is good at doing some calculations).
Where possible use local copies of tables in exclusive mode.
Someties multiple SQL is faster than a single one (or xBase approaches).
Store ... is faster than =, scan..endscan is faster than do while skip..enddo etc series of optimizations.
Arrays are generally faster than cursor processing...(but there are places they might be much more slower). If you need string parsing, sometimes the fastest approach is to create a combo or listbox object-if not using FLL,DLL.
...
Does a class execute any quicker? Hmm maybe slower but generally difference is not calculatable within a large process. Debatable.
PS: Some items here might lead to long running discussions:)
Cetin