StarSQL implements a Fetch Ahead mechanism to retrieve data from the host in anticipation of the client application requests. Data is fetched from the host, stored in the driver, and returned to the application on request. For receiving large result sets from the database, enabling the FetchAhead option can help optimize the network connection and improve performance. Performance with smaller result sets is unaffected by the FetchAhead option.
You can enable or disable the FetchAhead option when you set up a data source using the Data Source Setup Wizard. For TCP/IP connections, the default for FetchAhead is Yes (enabled). For all other network protocols, the default for FetchAhead is No (not enabled).