1. Forum
  3. Main PGNP Forum
  5. 64-bit, Very Large Databases
  7. Single Row Mode for extremely large recordsets

Single Row Mode for extremely large recordsets

More
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).
Last edit: 4 years 7 months ago by admin.

Please Log in or Create an account to join the conversation.

  1. Forum
  3. Main PGNP Forum
  5. 64-bit, Very Large Databases
  7. Single Row Mode for extremely large recordsets
Time to create page: 0.056 seconds
Powered by Kunena Forum