> Are there any recent comparative performance tests available?

Every database will perform differently based on how it is written. Some 
commands are compiled directly to machine code in these they may execute up to 
100x faster, others require calls to the 4D engine. Some will have no 
improvement such as a query.

Compiling does not speed up network, or database operations, so the speed 
advantage is only seen in method execution (code that is not DB operations). 
Things like sort array won't speed either up unless you rolled your own sort, 
the 4D commands internally run at compiled speeds. Loops and things where you 
modify variables or arrays will greatly speed up.

I think it is good to write/make code so it can be compiled no matter how you 
decide to execute the code in production. The compiler catches a lot of 
programming mistakes that are easy to fix once you know where they are. So if 
you adopt that philosophy then you could run it compiled and weigh the 



Privacy Disclaimer: This message contains confidential information and is 
intended only for the named addressee. If you are not the named addressee you 
should not disseminate, distribute or copy this email. Please delete this email 
from your system and notify the sender immediately by replying to this email.  
If you are not the intended recipient you are notified that disclosing, 
copying, distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

The Alternative Investments division of UMB Fund Services provides a full range 
of services to hedge funds, funds of funds and private equity funds.  Any tax 
advice in this communication is not intended to be used, and cannot be used, by 
a client or any other person or entity for the purpose of (a) avoiding 
penalties that may be imposed on any taxpayer or (b) promoting, marketing, or 
recommending to another party any matter addressed herein.
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com

Reply via email to