Query performance applying security rules - HxGN SDx - Update 64 - Administration & Configuration

Administration and Configuration of HxGN SDx

Language
English
Product
HxGN SDx
Search by Category
Administration & Configuration
SmartPlant Foundation / SDx Version
10

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.