Using a scheduled trigger on a large dataset

I’m attempting use a scheduled trigger to see if the time of two documents (think of two documents as a ‘session’ with a start time and end time) overlap. My scheduled trigger runs once a day and will return a large array of documents, which then must be compared to other documents to see if there is any overlap.

I have this working in my scheduled trigger in practice by passing in an array of 10 documents, but in reality, when the trigger runs, it will be processing up to 1 thousand documents. I’m finding that my trigger often exceeds the execution time limit and errors out. Is there any way to increase the execution time limit in a scheduled trigger? I’ve read about event bridging, but that functionality seems to only be available in database triggers, not scheduled triggers.

I solved this by using .explain() to see what kind of query was running and adding the appropriate index