Set these options in the data source or connection string:
CreateDB=1 //Set this option the first time a connection is made, to force a new map to be created due to the ConfigOptions change above, then change back to 2..
WSFetchSize=10000 //Use larger values if stmtCallLimit is hit, use smaller values if error "Poor performing query" is still encountered.
EnablePagingWithOrderByID=1 //This is the default value, so it probably does not need to be explicitly set.
Note: For DataDirect Cloud, NamedID Behavior is set on the Mapping tab under Set Map Options.