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).