Solved

Properties Global database settings


Where can I find a description of the properties of the Global Database settings in general and in my case regarding a SQL server DB especially the “max rows to copy”. I have used 0 (hopefully then there is no limit but I have also seen that values are used).

icon

Best answer by Christian Hauggaard 22 May 2023, 10:01

View original

2 replies

Userlevel 4
Badge +5

Hi Lorenzo

You see it as using incorrect settings in the various environments?

The settings are saved in the repository, but they are not different than what you can see if you look at the settings in the environment properties menu. The way it could use different settings is if one of the areas in one of the environment is set to not use a global database despite one being available.

Also not related to this, using 0 as the max rows to copy is not best practice. We always suggest having a value in this field, especially when using the ODX. The only times where it will not potentially give issues is when working with two databases on the same server or ones using direct read.

If you use 0 and connects to the ODX with a DWH we at times see frequent timeouts and slow transfers due to all rows being stored in memory.

Userlevel 4
Badge +5

Hi @Lorenzo 

Please find info regarding the global database properties for a data warehouse database here: https://legacysupport.timextender.com/hc/en-us/articles/360051847691-Data-Warehouses

The Max rows to copy refers to “the batch size when using ADO.net transfer”.

Reply