Jim Land (cont’d)
Query infrequently and write queries that run quickly.
- Querying the database is the slowest operation you can perform, since you have to access a hard drive. Query once, no problem. Query a lot, and your app runs slow. Use the new query-of-queries feature to avoid that trip to the db.
Database design: One piece of information goes in exactly one place, one time.
- Never enter the same piece of information again, in another table, for any reason.