Hi.
I have Customer Insigth, and Customer Service environment.
In Customer Insigth, there are 4.5M profiles.
From Customer service, We are quering profiles, using the native virtual table msdynci_customerprofie, filtering by and attribute, de customer's document number.
This where working well en our dev environment, with less profiles, but in our pre production environmnet, We found this problem.
And example of the query in a plugin.
var query_msdynci_rut = "1111111-1";
var query = new QueryExpression("msdynci_customerprofile");
query.TopCount = 1;
query.ColumnSet.AddColumns("msdynci_email", "msdynci_last_name", "msdynci_fst_name", "msdynci_rut", "msdynci_customerid", "msdynci_customerprofileid");
query.Criteria.AddCondition("msdynci_rut", ConditionOperator.Equal, query_msdynci_rut);
This ended up in a timeout.
It also happens if I try to filter by de primary key, the msdynci_customerprofileid
Why Customer insigth is not capable to respond to such simple query?