While the Classificator receive the sample rows, it uses server-side cursor. It means that each returned row uses dedicated MS RPC. It takes a lot of time, uses additional network request and response time for each rows.
Is it possible to use client site local cursor to return all rows in one RPC?
(should be Client-Side Local/Static)
- JDBC connection property responseBuffering String ["full" | "adaptive"] must be set to "full" or use the setResponseBuffering method of the SQLServerStatement object.
Do not place IBM confidential, company confidential, or personal information into any field.