Single Row Mode for extremely large recordsets
2 years 6 months ago - 2 years 6 months ago #14470
by admin
admin created the topic: Single Row Mode for extremely large recordsets
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: 2 years 6 months ago by admin.
Please Log in or Create an account to join the conversation.
Time to create page: 0.060 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
64-bit, Very Large Databases
- Single Row Mode for extremely large recordsets