If system performance seems slow, Database Administrators
can run database statistics against several entity database tables
to improve both pipeline performance and the Visualizer user experience.
Pipeline tables
If pipeline performance
seems slow, try running database statistics against the following
entity database tables:
- DQM_NAME_DICT
- NAME
- ADDRESS
- NUMS
- ATTRIBUTES
- EMAIL_ADDR
- DSRC_ACCT
- SEP_RELATIONS
- SEP_ROLES
- ENTITY
- DISCLOSED_RELATIONS
- UMF_LOG
- UMF_EXCEPT
Visualizer tables
If Visualizer users complain
that the Visualizer performance seems slow, try running database statistics
against the following entity database tables:
- ER_ENTITY_SCORE
- ER_HISTORY
- ER_RELOCATION
- ER_DETAIL
- ER_ACCT_SCORE
- ER_ENTITY_STATE
- ER_FORCED_LOG
- SEP_CONFLICT
- SEP_CONFLICT_REL
- SEARCH
- APP_ACTIVITY_CODES
- APP_ACTIVITY_HISTORY
- APP_CONFLICT_GROUP
- APP_INBOX
- APP_ROLE
- APP_SEND
- MATCH_MERGE_RULES
- CONFLICT_RULES
In addition, because the Visualizer also uses a background pipeline
to perform several Visualizer tasks (such as adding entities, finding
entities by entity resolution, and disclosing relationships), Database
Administrators should also run database statistics against the database
tables listed in the Pipeline tables section.