Query performance applying security rules - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

When applying security rules for complex objects or documents, you can optimize performance by configuring security rules on the object level you want the security rule to be applied, rather than at a higher level. For example, the following security rule is applied at the SPFDesignDocRevision level.

SPFDesignDocRevision: Obj.SPFRevState='e1CURRENT'

When a security rule is configured to relate properties on revisions at a higher level, such as at the Master level, running the security rule may affect performance as it must do an extra expansion for each property. For example:

SPFDesignDocMaster: Obj->SPFDocumentRevisions_12.SPFRevState)='e1CURRENT'

  • When you query for a version, the Master and revision are examined for any security rules.

  • When you query for a revision, only the Master is examined for security rules.