]> Raphaël G. Git Repositories - airbundle/commitdiff
Add index for findAllPendingApplication and findBestApplicationById
authorRaphaël Gertz <git@rapsys.eu>
Sun, 13 Dec 2020 21:41:42 +0000 (22:41 +0100)
committerRaphaël Gertz <git@rapsys.eu>
Sun, 13 Dec 2020 21:41:42 +0000 (22:41 +0100)
Resources/config/doctrine/Session.orm.yml

index a9381475e5fe7083dbf4f89484a7b8fb77fd037b..cccafa6fa7fdaf79a75259e26086014b21527e58 100644 (file)
@@ -69,5 +69,18 @@ Rapsys\AirBundle\Entity\Session:
         date_location_slot:
             columns: [ date, location_id, slot_id ]
     indexes:
         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 ]