Single Row Mode for extremely large recordsets
4 years 7 months ago - 4 years 7 months ago #14470
by admin
Single Row Mode for extremely large recordsets was created by admin
To enable the Single Row Mode add CURSOR=SINGLEROW to the Extended Properties of the connection string (in linked server - Provider String).
This mode could be used for ETL, Analytics, etc., basically for any scenario where forward-only cursor is needed. It allows processing of extremely large record sets (over billion records).
For more details refer to the Developer's Manual (available from the Download page).
This mode could be used for ETL, Analytics, etc., basically for any scenario where forward-only cursor is needed. It allows processing of extremely large record sets (over billion records).
For more details refer to the Developer's Manual (available from the Download page).
Last edit: 4 years 7 months ago by admin.
Please Log in or Create an account to join the conversation.
Time to create page: 0.056 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
64-bit, Very Large Databases
- Single Row Mode for extremely large recordsets