Request Adobe Campaign Classic

Hello,

We are wondering why Adobe Campaign Classic adds extra fields when querying the database, and whether we can change this behaviour?

In a typology rule, we search the nmsDelivery table for specific rows by selecting the relevant expressions, operators and values (joined with nmsOperation). The query box allows us to view the “Corresponding SQL query”. In the query we see, there is no mention of selecting mData, yet when Adobe Campaign Classic queries the database whilst this typology rule is applied, it retrieves the mData information for the nmsDelivery table, which increases the load on the database and, with concurrent processes, can cause errors.

Hence my question: why does Adobe Campaign Classic use this additional field? Is it possible to change this behaviour to reduce the load on the database?

Kind regards,