Need to test out different grouping strategies for a matching process I'm building. Problem is there are too many records to query the data for a count(). In dev console I get a 'communication failure: No response from the server' message. And in workbench I get the future_get-9-1588268637 error.
QUERY FOR BATCH
SELECT count()
FROM data__c
WHERE date__c >= 2020-02-01 AND
date__c <= 2020-02-28 AND
data2__r.program__c LIKE '%test%'
I know there are people who have to work with millions of records.. how come it's so difficult to work with a few hundred thousand? Any suggestions
Thank you
data.prgoram__c
instead ofprgoram__c
? Or is the field name actuallyProgram__c
?prgoram__c
(or whichever field it is) as ExternalId to force Salesforce to index it. (I'm afraid that to index date fields you will have to get in contact with support)