Designing for performance

Most performance gains derive from good database design, thorough query analysis, and appropriate indexing. You can realize the largest performance gains by establishing a good database design and working with the Adaptive Server query optimizer as you develop your applications.

You can also improve performance by analyzing how an application works with Adaptive Server. For example, a client may initially send rows with a size of 1KB to Adaptive Server and then wait for Adaptive Server to acknowledge receiving the rows before it sends the next row. You may find that the performance between the client and Adaptive Server improves if the client consolidates or batches the rows it sends to Adaptive Server, greatly simplifying the process and requiring less interaction between Adaptive Server and the client.

You can also use hardware and network analysis, to locate performance bottlenecks in your installation.