Improving query performance

From InterBase
Jump to: navigation, search

Go Up to Working with Queries


Following are steps you can take to improve query execution speed:

  • Set the TIBQuery component’s UniDirectional property to True if you do not need to navigate backward through a result set (SQL-92 does not, itself, permit backward navigation through a result set).
  • Prepare the query before execution. This is especially helpful when you plan to execute a single query several times. You need only prepare the query once, before its first use. For more information about query preparation, see Preparing a query.

Topics