Configuration Mode Commands : SteelHead Configuration Commands : MS-SQL Blade Support Commands : protocol ms-sql fetch-next enable
  
protocol ms-sql fetch-next enable
Enables pre-fetching requests to request the next row in MS Project. The server-side SteelHead pre-fetches sequential row results and the client-side SteelHead caches them. You decide which cursors or queries are cacheable.
Syntax
[no] protocol ms-sql fetch-next enable
Parameters
None
Usage
To determine which cursors or queries are cacheable, you configure rules. By default, all fetch next queries are cacheable.
You must restart the SteelHead service after enabling this feature.
The no command option removes pre-fetching requests.
Example
amnesiac (config) # protocol ms-sql fetch-next enable
amnesiac (config) # service restart
Product
SteelHead CX, SteelHead EX, SteelHead-v, SteelHead-c
Related Commands
show protocol ms-sql