Improve performance of AppointmentRules.getOverlap() query

Description

The AppointmentRules.getOverlap() method used by BookingServiceImpl can sometimes take many seconds to return a result for a single row.

On closer inspection, this is because it is using the wrong index. Duplicate the date range onto the participation join so that the correct index is used.

Environment

None

Activity

Fixed

Details

Assignee

Reporter

Time tracking

4h logged

Components

Fix versions

Affects versions

Priority

Who's Looking?

Open Who's Looking?

Created May 15, 2020 at 5:27 AM
Updated May 18, 2020 at 2:30 AM
Resolved May 18, 2020 at 2:30 AM
Who's Looking?