As my database becomes larger and larger, especially querying elements like EventLogEntry, I'm trying to figure out how to increase the speed of my python scripts.
What affects the speed of specifically the find() query? If I do a find() on a single id, is that quicker than a find which has to satisfy multiple filters? If it has to satisfy multiple filters, does it matter what order they are presented? Are certain fields faster to query than others?
Are queries of fields that return integers and text faster than multi-entity fields? Are queries faster if they return fewer fields?
If I am looking for Event Log Entries from a particular user and within a particular id-range, is it faster to get the id-range first and then filter based on the user?
Is find_one() faster than find()? Is finding an element faster than finding nothing? Vice versa?
So many questions...