s7clarke10 / tap-sybase

A Singer Tap for Sybase Databases, it should be compatible with Pipelinewise and Meltano
GNU Affero General Public License v3.0
1 stars 4 forks source link

Feature/support cursor fetch many #7

Closed s7clarke10 closed 2 years ago

s7clarke10 commented 2 years ago

This feature introduces a new parameter cursor_array_size.

By default it is set to a value of 1. By increase the size it will fetch more than one record improving performance in low latency networks by reducing the number of round trips to the database.

Increasing to a size of 10,000 is recommend to get a boost in performance for large tables. Be careful to not set too high as it will require additional memory.