Site Merge Process Performance

Site Merge Indexes:

You should find that the following optional index will optimize the performance for Merge Sites:

Table	Column	Index Name	Unique?
site	alias2site	alias_s_index	No

This index definition is included in the installation files for Release 4.1 of Dovetail Agent.

In addition, Merge Sites can be VERY slow on a system that contains a significant amount of data. The reason for this is that the merge (or preview) process must search for objects to be moved from alias to master in the merge process.

For example, suppose that the case table contains millions of cases. When a contact (or site) is merged, the system must check every case to see if it is associated with the alias contact/site. If the relation column is not indexed, this will cause a table scan.

As an example, one user of site merge reported times of up to 1 hour to process a single alias site (due to the large amount of data in their Clarify system). Adding the proper indexes reduced that time to less than 6 seconds for the same merge.

In a single merge, there are a large number of tables that must be searched. But not all of them will contain a large number of rows, and thus not all of them need to be indexed.

Site Merge Columns:

The following table list the tables (and columns) that will be used to perform the merge operation. If there are a large number (over 1000) rows in the table listed, then you should consider adding an index on the column listed to improve performance.

Table Name	Column Name	Clarify Version
part_vend	part_vend2site	All
inv_locatn	inv_locatn2site	All
phone	phone2site	All
case	case_distr2site	All
doc_inst	doc_inst2site	All
ship_parts	carrier2vendor	All
site	child_site2site	All
trans_record	trans_record2site	All
productbin	direct_prdbin2site	All
act_entry	act_entry2site	All
productbin	prdbin2site	All
acd_call	acd_call_site2site	All
demand_hdr	open_reqst2site	All
demand_hdr	bill_reqst2site	All
site	support_office2site	All
employee	supp_person_off2site	All
site_part	all_site_part2site	All
site_part	site_part2site	All
case	case_reporter2site	All
contact_role	contact_role2site	All
inv_role	inv_role2site	All
mtm_site5_contract0	cust_loc2contract	All
mtm_site5_contract0	contract2site	All
alert	alert2site	4.5+
E_addr	eaddr2site	4.5+
per_site_role	per_site_role2site	4.5+
C_site_role	c_site_role2site	4.5+
sit_prt_role	sit_prt_role2site	4.5+
site_addr_role	site_addr_role2site	4.5+
bus_site_role	bus_site_role2site	4.5+
contr_schedule	bill_to2site	5.0+
quick_quote	q_quote2site	5.0+
contr_itm	quoted_at2site	5.0+
contr_itm	covered_by2site	5.0+
sit_csc_role	csc_role2site	5.0+
contr_schedule	ship_to2site	5.0+
exchange	partner2site	5.0+
scr_run	scr_run2site	6.0+
exc_sit_role	exc_sit_role2exchange	7.0+
part_num	part_num2site	7.0+
vendor_part	vendor_part2site	7.0+
shp_sit_role	shp_role2site	9.0+
bus_org	primary_site2bus_org	11.5+
order_action	site2order_action	12.0+
order_shipping	site2order_shipping	12.0+
site_ba_role	site2site_ba_role	12.0+
blg_argmnt	primary_site2blg_argmnt	12.0+
contract	bill_to2site	13.0+
con_bus_role	bus_address2site	13.0+
con_blg_argmnt_role	ba_address2site	13.0+
con_fin_accnt_role	fa_address2site	13.0+
con_sp_role	sp_address2site	13.0+
con_ppb_role	ppb_address2site	13.0+
con_pym_role	pym_address2site	13.0+
impact	impact2site	13.0+

Site Merge Process Performance

Site Merge Indexes:

Site Merge Columns:

See Also

Next