Tech Tip: Why compile your database?
PRODUCT: 4D | VERSION: 2003 | PLATFORM: Mac & Win
Published On: June 24, 2004
Compiling your database allows you to check your code syntax, gives you faster execution, and protects your application from modification. When you compile your database, your code statements are systematically checked and any syntax errors or ambiguities are reported. Accordingly, the code is translated all at once into machine language and the variables are attached to memory addresses that can be accessed directly--thus, speeding its execution. Furthermore, running in compiled mode can protect your application as it prevents users from accessing the design mode.