For applications that use SQL queries to access data, the database query guidelines discussed in this section must be followed to minimize the impact on the Manager’s performance. Frequent, large queries can negatively impact the performance of the Manager.
Note
Copy the Manager database on a different system before you run your queries.
The following are the guidelines that you must follow:
- Avoid joins – joined queries lock the entire table for longer periods of time.
- Include the index-key as the first condition, wherever possible. Some examples of index keys are uuid and creation time.
- Allow time between queries to accommodate database updates. Some users leave at least a few minutes between queries.
- Query the small increments of data possible. The maximum number should be 3000 (use a limit class).