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