My query does not respond because "CreatedDate" is not indexed. I used the "allowDiskUse" parameter but it still does not respond. What can I do?
pymongo versiyon -> 3.11.3
from pymongo import MongoClient,DESCENDING,ReadPreference
from datetime import datetime
myclient = MongoClient("mongodb://xxx:yyy@zzz:27017")
mydb = myclient['db_name']
mycol = mydb["col_nane"]
pipe=[{"$match":{"Channel":"XXXX","CreatedDate":{"$gt":datetime(2021, 4, 20, 15, 36, 58)}}}]
mycol.aggregate(pipe,allowDiskUse=True)