Problem

Message Tracker search for linked message takes a lot of time. Search is getting timed out.

Resolution

Related messages for standard processing

Show related messages –

Enabled by default. When this option is selected on this page, Message tracker users who launch message searches have the option to view message linkages before and after the processing phase. The relationship can only be determined for messages that go through B2Bi standard message processing.

If your message inquiry includes a large number of messages and becomes exceptionally slow, you can add an index to your database to reduce the query time. Add your index on the CustomData table, for the columns DataValue, Name, and MessageOID.

The following is an example only of the query to add the index:

CREATE INDEX CUSTOMDATA_PERFORMANCE ON CUSTOMDATA ("DATAVALUE","NAME","MESSAGEOID");

For MySQL, the index creation query should be:

CREATE INDEX CUSTOMDATA_PERFORMANCE ON CUSTOMDATA(`DATAVALUE` (500),`NAME`,`MESSAGEOID`);