The Simba MongoDB ODBC Driver is capable of using double-buffering to improve driver performance during SELECT operations.
The impact of double-buffering depends on how the transfer speed of your network compares to the data processing speed of the driver. If the transfer speed is significantly higher, then enabling double-buffering allows the driver to make full use of the network's capabilities. Conversely, if the transfer speed is considerably lower, the additional processes involved in double-buffering might cause a decrease in performance.
To make optimal use of double-buffering, you need to set an appropriate buffer size. A buffer size that is too small might decrease performance, while a buffer size that is too large might diminish the performance improvements from double-buffering. If the transfer speed of the network is slow, the additional time spend processing a large buffer size might cause a decrease in performance.