i've some performance issues in a custom Portal.
There is some kind of active directory users and computers in the web. In case of very large groupmemberships i run into performance issues.
I monitored and debugged the application and have a question regarding the following log entry:
FilterFullScan ADSAccountInADSGroupTotal; UID_ADSAccount = ( SingleProperty('ADSAccount', 'UID_ADSAccount', "some whereclause''))) ) 10087 ms
What does FilterFullScan mean?
You are filtering a table, and querying the database for every single row in the table (using the SingleProperty function).
Fetch the database value once, store it in a field, and use that value to compare.
found and solved. Thx