Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Faster execution
Message
 
To
03/12/2005 10:33:49
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01074569
Message ID:
01077918
Views:
16
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
Zakaria al Azhar
My blog on Actuaris.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform