v5:userguide:portable_sql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
| reference:portable_sql [2015/12/04 18:36] – mnewnham | reference:portable_sql [2015/12/04 18:37] – [Final Thoughts] mnewnham | ||
|---|---|---|---|
| Line 272: | Line 272: | ||
| The best way to ensure that you have portable SQL is to have your data tables designed using sound principles. Learn the theory of normalization and entity-relationship diagrams and model your data carefully. Understand how joins and indexes work and how they are used to tune performance. | The best way to ensure that you have portable SQL is to have your data tables designed using sound principles. Learn the theory of normalization and entity-relationship diagrams and model your data carefully. Understand how joins and indexes work and how they are used to tune performance. | ||
| - | |||
| - | Visit the following page for more references on database theory and vendors: [[http:// | ||
| (c) 2002-2014 John Lim. | (c) 2002-2014 John Lim. | ||
v5/userguide/portable_sql.txt · Last modified: 2020/12/30 21:32 by peterdd