Performance Trade-offs

This section describes the performance trade-offs in developing an add-in tool, and provides guidelines for improving efficiency.

Impact of Indexes on Performance

In general, indexes can improve the performance of queries but require more resources for data updates. Consequently, you should define the minimum number of indexes necessary to optimize frequent queries. If your add-in tool will have many records, indexes can significantly improve the performance of queries but can degrade the performance of updates. Typically, indexes have only a minor effect on performance of queries for tools with 1,000 records or fewer. Because indexes can only be specified when the tool is first added to a workspace, you should do performance testing of add-in tools with many records before you deploy the tool into production.