• State Verified Answer
  • Locked Locked
  • Replies 2 replies
  • Subscribers 94 subscribers
  • Views 1609 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Webdesigner V6 FilterFullScan?

Martin.Guckes
over 5 years ago

Hi there,

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?

Thx

Martin

Parents
  • +1 over 5 years ago

    Hi Martin,

    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.

    HTH

    Hanno

Reply
  • +1 over 5 years ago

    Hi Martin,

    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.

    HTH

    Hanno

Children