[ODBC-369] Add option not to cache the whole resultset on the client, but fetch it row by row Created: 2022-07-19  Updated: 2023-01-24  Resolved: 2022-08-19

Status: Closed
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: 3.1.16
Fix Version/s: 3.1.17

Type: New Feature Priority: Critical
Reporter: Lawrin Novitsky Assignee: Lawrin Novitsky
Resolution: Fixed Votes: 1
Labels: None

Issue Links:
Blocks
blocks MXS-2709 ETL / Data Migration Service Closed

 Description   

This can help reduce memory required on the big resultsets. If selected, this option will not force use of forward-only cursors, i.e. "force use of of forward only cursor" won't get automatically selected, but result streaming will be used for those statements, for which forward-only cursor type is set. In this way streaming will be possible to use not for all query results - user will have control over that.

 Comments   
Comment by Lawrin Novitsky [ 2022-08-19 ]

The option for not caching the whole RS on the client, but fetch it row by row
from the server has been added. The name of the option is NO_CACHE or STREAMRS is the
alias, 1048576 is the OPTION's bit. The feature only comes in action with
FORWARD_ONLY cursors. Thus it will always be used if combined with FORWARDONLY
option. Some features cannot work in combination with this feature, and
the error HY000 with the message "The requested operation cannot be
executed at the moment...". In particular positioned operation on open
cursor cannot be performed, if streaming is used for cursor.

Generated at Thu Feb 08 03:28:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.