Adobe Campaign: Queries against tsEvent take a long time

Last update: Thu May 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

Description description

Environment

Campaign Classic
Campaign
Campaign Standard

Issue/Symptoms

When creating queries against the tsEvent field on the nmsBroadLogRcp table in Classic and Standard versions of Adobe Campaign, queries take a long time to return or timeout.

Resolution resolution

This is because there is no index on the tsEvent table out of the box. An enhancement (CAMP-37074) has been created to include an index in the out-of-the-box code moving forward.

In the meantime, it is recommended to either not query large subsets of data using the tsEvent field or manually add an index on the tsEvent field.

recommendation-more-help

3d58f420-19b5-47a0-a122-5c9dab55ec7f