Apex开发指南--一些limit的优化方法

SOQL Limits

1，Always use bulk syntax (see Bulk Patterns later in this chapter).
2，Use before-triggers instead of after-triggers where possible (allows
modification of fields without a SOQL query and DML update).
3，Cache query results if your design allows.
4，Include fields from related objects in a single query.

DML Limits

There is a limit to the number of DML (Database) operations you can
perform within an execution context.
Combine DML operations on each object type into a single bulk
DML operation.
If your program flow calls for DML operations at different places in
your code, don’t perform the DML operation right away. Instead,
store a reference to the object in a list, set or Map. Then perform a
DML operation on all objects at once as the last part of your
operation.

H