User Tools

Site Tools


replicator_optimization

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
replicator_optimization [2019/01/10 17:54]
robyn.lin
replicator_optimization [2019/08/29 17:32] (current)
ayessa.medrano
Line 15: Line 15:
  
 Note if the properties do not exist, see [[http://​wiki.servicenow.com/​index.php?​title=Adding_a_Property#​gsc.tab=0|Adding a Property]] as ServiceNow will use the default values if the properties do not exist in an instance. Note if the properties do not exist, see [[http://​wiki.servicenow.com/​index.php?​title=Adding_a_Property#​gsc.tab=0|Adding a Property]] as ServiceNow will use the default values if the properties do not exist in an instance.
 +
 +Note that adjusting the HTTP Client Connection Management properties may affect performance of the instance.
  
 === Add Indexes to Perspectium system tables === === Add Indexes to Perspectium system tables ===
Line 28: Line 30:
 | PSP Out Message tables (psp_out_message,​ u_psp_attachment_out_message,​ u_psp_audit_out_message,​ u_psp_observer_out_message) ​ | psp_out_query3| single, non-unique ​  | Sequence (u_sequence)| | PSP Out Message tables (psp_out_message,​ u_psp_attachment_out_message,​ u_psp_audit_out_message,​ u_psp_observer_out_message) ​ | psp_out_query3| single, non-unique ​  | Sequence (u_sequence)|
 | PSP Out Message tables (psp_out_message,​ u_psp_attachment_out_message,​ u_psp_audit_out_message,​ u_psp_observer_out_message) ​ | psp_out_query4| composite, non-unique| Created (sys_created_on) \\ Sequence (u_sequence)| | PSP Out Message tables (psp_out_message,​ u_psp_attachment_out_message,​ u_psp_audit_out_message,​ u_psp_observer_out_message) ​ | psp_out_query4| composite, non-unique| Created (sys_created_on) \\ Sequence (u_sequence)|
-| PSP In Message (psp_in_message) ​   | psp_in_query ​ | single, non-unique ​  | Created (sys_created_on)|+| PSP In Message (psp_in_message) ​   | psp_in_query ​ | single, non-unique ​  | Created (sys_created_on), name, key, u_sequence|
 | PSP In Message (psp_in_message) ​   | psp_in_query2 | single, non-unique ​  | State (state)| | PSP In Message (psp_in_message) ​   | psp_in_query2 | single, non-unique ​  | State (state)|
 | PSP Log Message (u_psp_log_message)| psp_log_query | single, non-unique ​  | Created (sys_created_on)| | PSP Log Message (u_psp_log_message)| psp_log_query | single, non-unique ​  | Created (sys_created_on)|
 | PSP Log Message (u_psp_log_message)| psp_log_query2| composite, non-unique| Created (sys_created_on) \\ Type (u_type)| | PSP Log Message (u_psp_log_message)| psp_log_query2| composite, non-unique| Created (sys_created_on) \\ Type (u_type)|
-| PSP Properties (u_psp_properties)| ​ u_psp_properties_u_name | single, non-unique ​  | Name (u_name)|+| PSP Properties (u_psp_properties)| ​ u_psp_properties_u_name | single, non-unique ​  | Name (u_name) ​
 +| PSP Replicate Conf (u_psp_replicate_conf) | u_psp_replicate_conf | single, non-unique | active, sync_direction,​ table_name ​|
 ==== Sharing Instance ==== ==== Sharing Instance ====
  
replicator_optimization.1547171660.txt.gz · Last modified: 2019/01/10 17:54 by robyn.lin