KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Note: Breaking the Rules to Improve Performance, Part 1—Expanding the Concept of a Key
PRODUCT: 4D | VERSION: 3.x | PLATFORM: Mac & Win
Published On: July 1, 1996
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

There are many rules that we 4D developers have learned to live by over the years. There are three rules in particular, that can adversely affect the performance of an application in a WAN or a dial-up situation.
• Don't use subfiles
• Don't use 4D's built-in relational lookups; write your own.
• Don't duplicate data—normalize
This technical note, talks about performance-enhancing ways to break rule #1 (subfiles) and rule #3 (de-normalized data).

WIN
http://usdl.4d.com/TN/1996/Windows/TN_1996_31-32_(JUL)/96-31_Performance_1.exe

MAC
http://usdl.4d.com/TN/1996/MacOS/TN_1996_31-32_(JUL)/96-31_Performance_1.hqx