Bulk Fetch Rows of TimesTen Data

TimesTen provides the TT_PREFETCH_COUNT ODBC statement option to enable an application to fetch multiple rows of data.

This feature is available for applications that use the Read Committed isolation level. For applications that retrieve large amounts of TimesTen data, fetching multiple rows can increase performance greatly. However, locks are held on all rows being retrieved until the application has received all the data, decreasing concurrency. See Prefetching Multiple Rows of Data.