====== Automatic roles by attribute performance ======

<note tip>Price for rule type: //contract// **<** //identity// **<** //contract EAV// **<** //identity EAV//</note>

This page contains information about performance and automatic role by attribute.

All tests was done with PostgreSQL database in version 9.6.

Performance test was executed by recalculation by single user. This mean normal save identity/contract and their eavs. Then was explained query composed for given rules.


===== Result =====
**Test scenario:**
* Rule 1. - identity EAV equals

Explain result **0.56 min** and **47.53 max**

----

**Test scenario:**
  * Rule 1. - identity EAV equals
  * Rule 2. - identity EAV is not empty

Explain result **0.84 min** and **55.52 max**

----

**Test scenario:**
  * Rule 1. - identity EAV equals
  * Rule 2. - identity EAV is not empty
  * Rule 3. - identity EAV multivalued equals

Explain result **1.12 min** and **63.49 max**

----

**Test scenario:**
  * Rule 1. - identity EAV equals
  * Rule 2. - identity EAV is not empty
  * Rule 3. - identity EAV multivalued equals
  * Rule 4. - identity phone contains

Explain result **1.40 min** and **72.51 max**

----

**Test scenario:**
  * Rule 1. - identity EAV equals
  * Rule 2. - identity EAV is not empty
  * Rule 3. - identity EAV multivalued equals
  * Rule 4. - identity phone contains
  * Rule 5. - contract position is not empty

Explain result **1.40 min** and **72.51 max**

<note tip>Rule for contract entity doesn't need extra cost. Because connection to contract exists every time.</note>

----

**Test scenario:**
  * Rule 1. - identity EAV equals
  * Rule 2. - identity EAV is not empty
  * Rule 3. - identity EAV multivalued equals
  * Rule 4. - identity phone contains
  * Rule 5. - contract position is not empty
  * Rule 6. - identity EAV multivalued is not empty

Explain result **1.68 min** and **72.13 max**

----

**Test scenario:**
  * Rule 1. - identity EAV equals
  * Rule 2. - identity EAV is not empty
  * Rule 3. - identity EAV multivalued equals
  * Rule 4. - identity phone contains
  * Rule 5. - contract position is not empty
  * Rule 6. - identity EAV multivalued is not empty
  * Rule 7. - identity EAV multivalued is empty

Explain result **1.96 min** and **95.05 max**

----

**Test scenario:**
* Rule 1. - identity EAV equals
* Rule 2. - identity EAV is not empty
* Rule 3. - identity EAV multivalued equals
* Rule 4. - identity phone contains
* Rule 5. - contract position is not empty
* Rule 6. - identity EAV multivalued is not empty
* Rule 7. - identity EAV multivalued is empty
* Rule 7. - identity username not start with

Explain result **2.24 min** and **95.72 max**

----

**Test scenario:**
* Rule 1. - identity EAV multivalued (shorttext) is empty 

Explain result **0.56 min** and **39.51 max**

<note important>Rule with is empty and multivalued for identity is the most expensive.</note>

----

**Test scenario:**
* Rule 1. - contract EAV multivalued is empty 

Explain result **0.42 min** and **24.77 max**