Design
#24
Use as few plugins as possible
Avoid using plugins (Flash Player, Java and Silverlight virtual machines, etc.) because they can be a heavy drain on resources (CPU and RAM). This is especially true with Adobe’s Flash Player, to such an extent that Apple decided to not install the technology on its mobile devices to maximize battery life. Favor standard technology such as HTML5 and ECMAScript.
Development
#59
Limit the number of results
When possible, use the LIMIT statement to specify the number of results to return. This helps minimize the amount of CPU and RAM used to find the relevant records.
The improvement in performance will be even greater if the records contain many large fields.
