Slow filter

Hello,

I'm trying to filter a lookup based on Contact entity using two conditions. I'm trying to get all the contacts assigned to a certain account or all contacts that are connect to (by a relation) a certain account. I have defined this attribute and it is working fine.

"FilteredContact": {

         dataValueType: Terrasoft.DataValueType.LOOKUP,

         lookupListConfig: {

          filters: [

               function() {

                var accountId = this.get("Account").value;

                var filterGroup = Ext.create("Terrasoft.FilterGroup");

                filterGroup.logicalOperation = this.Terrasoft.LogicalOperatorType.OR;

                filterGroup.add("IdFilter", Terrasoft.createColumnFilterWithParameter(

                                  Terrasoft.ComparisonType.EQUAL, "Account", accountId));

                filterGroup.add("ConnectedFilter", Terrasoft.createColumnFilterWithParameter(

                                        Terrasoft.ComparisonType.EQUAL,

                                        "[VwContactRelationship:Contact].RelatedAccount", accountId));

                return filterGroup;

             }

            ]

  }

}

But it's very slow in many cases. Sometimes the execution lasts more than 30 seconds.

I have checked the generated sql query and the first criteria is translated with a simple where clause but the second criteria is translated to an exists clause. These 2 combined with an OR are executed very slowly. 

Do you have any idea how can I improve the performance of this filter? 

Thank you,

Cristian.