I have a table of events that have a start date, a duration (in days) and an end date (calculated off of start + end date). I need to check them for overlap, such that a given event can see other events that overlap with it. I have about 400 rows currently and what was once silky smooth is now 15s…

Optimizing Date Overlap Comparison

Paul_Danyliuk September 24, 2021, 11:37am 9

Bumping this old thread with a long-read that I just posted:

1 Like