From 3e8d87f1d79dd95bb46320d9164b7b4638ee6014 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Rapha=C3=ABl=20Gertz?= Date: Sun, 13 Dec 2020 22:41:42 +0100 Subject: [PATCH] Add index for findAllPendingApplication and findBestApplicationById --- Resources/config/doctrine/Session.orm.yml | 17 +++++++++++++++-- 1 file changed, 15 insertions(+), 2 deletions(-) diff --git a/Resources/config/doctrine/Session.orm.yml b/Resources/config/doctrine/Session.orm.yml index a938147..cccafa6 100644 --- a/Resources/config/doctrine/Session.orm.yml +++ b/Resources/config/doctrine/Session.orm.yml @@ -69,5 +69,18 @@ Rapsys\AirBundle\Entity\Session: date_location_slot: columns: [ date, location_id, slot_id ] indexes: - application_date_begin_slot_created: - columns: [ application_id, date, begin, slot_id, created ] + #XXX: used in SessionRepository::findAllPendingApplication + locked_date_begin_created: + columns: [ locked, date, begin, created ] + #XXX: used in SessionRepository::findBestApplicationById(s3) + application_locked_date_begin_slot_created: + columns: [ application_id, locked, date, begin, slot_id, created ] +# #XXX: tried for SessionRepository::findBestApplicationById(s2) +# location_slot_application_locked_date_begin: +# columns: [ location_id, slot_id, application_id, locked, date ] +# #XXX: tried for SessionRepository::findBestApplicationById(s3) +# application_locked_date: +# columns: [ application_id, locked, date ] +# #XXX: tried for SessionRepository::findBestApplicationById(s4) +# location_application_locked_date: +# columns: [ location_id, application_id, locked, date ] -- 2.41.0