> 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 differences. Neil -- 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 **********************************************************************