Hi Cetin,
>>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.
I have a question about using the independent c#exes. Is it possible to create something like this:
repl all field with ActnEx(par1,par2)
Where ActnEx is a C# function such that you can pass parameters to it?
Thanks beforehand.
>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