Section Access - pretty slow for the admins to open the document

[#1]

Hello Everyone,

I have section access implemented in one of our documents. When i make myself as one of the sales rep the document opens in under  a min. But when i make myself as the admin with access to all the data the document takes around 10 mins to open.

Without section access the document opens in under a min.

I tried switching from NTNames to Userid thinking it could be the AD directory issue ,but still it takes more than 10 mins to open. Any ideas what could be wrong?

Thanks,

Yogi

[andrespa]

Hi, it makes sense that takes more cause I assume that the Admin can see all the data For instance the Sales rep probably just could see one department or so.

Hope it helps,

Andrés

[andrespa]

Just saw just explanation that without Section acces the document takes under a minute to load.

Well, could you post how are you implementing the section acces then.

Cheers,

Andrés

[#4]

Below is my code in the section access.

TerritoryData1:

Load *,

Upper([Territory - Level 10 Name]) as [TERRITORY - LEVEL 10 NAME]

Resident TerritoryData;

drop Table TerritoryData;

ADMIN:

LOAD * INLINE [

    ADMIN

    A,

    QVPUBLISHERDEV,

    QVPUBLISHERQAS,

    QVPUBLISHERPR

];   

//SECTION ACCESS;

ACCESS:

LOAD

'ADMIN' as ACCESS,

ADMIN as NTNAME,

'*' as [TERRITORY - LEVEL 10 NAME]

Resident ADMIN;

Concatenate

LOAD

'USER' as ACCESS,

Upper([Territory - Level 8 Rep Login]) as NTNAME,

[TERRITORY - LEVEL 10 NAME]

Resident TerritoryData1

where len(trim([Territory - Level 8 Rep Login]))>=1  ;

Concatenate

LOAD

'USER' as ACCESS,

Upper([Territory - Level 9 Rep Login]) as NTNAME,

[TERRITORY - LEVEL 10 NAME]

Resident TerritoryData1

where len(trim([Territory - Level 9 Rep Login]))>=1  ;

Concatenate

LOAD

'USER' as ACCESS,

Upper([Territory - Level 10 Rep Login]) as NTNAME,

[TERRITORY - LEVEL 10 NAME]

Resident TerritoryData1

where len(trim([Territory - Level 10 Rep Login]))>=1  ;

Section Application;