SOQL query taking more time to execute from C#

Question

I've this query for checking existing contact on Salesforce

string queryString="select Id from Contact where Applicant_Email__c = '[email protected]' or email = '[email protected]' or Secondary_Email__c = '[email protected]' or Third_Email__c = '[email protected]' or Fourth_Email__c = '[email protected]'";

QueryResult qr = null;
        try
        {
            qr = binding.query(queryString);
        }

but this query is taking long time to execute, is there any way to optimize this query and make faster?

Answer 1

There are several things you need to consider here:

1. How many records are you getting back?
2. How long does the same query take in the developer console?
3. What is the selectivity of the SOQL query?

These points can direct you towards the problem. For example, if the same query is fast in the developer console and is returning a large number of records then the problem is most likely not using compression in the SOAP response. See SOAP Compression

If the selectivity of the query is poor then you should look at getting indexes added or reworking the query. See Make SOQL query selective.

Incidentally, the Salesforce StackExchange is a great place to ask Salesforce specific questions.