Details

      Description

      In large databases, (for me 2.8 million records in ResourcePermission), deleting a page takes a long time. This is the query that takes a long time (~6 seconds):

      SELECT * FROM ResourcePermission WHERE (ResourcePermission.companyId = 1) AND (ResourcePermission.primKey LIKE '326317_LAYOUT%');

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              daniel.kocsis Daniel Kocsis (Inactive)
              Reporter:
              amos.fong Amos Fong
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 28 weeks, 1 day ago

                  Packages

                  Version Package
                  6.0.X EE
                  6.1.1 CE GA2
                  6.1.20 EE GA2
                  6.2.0 CE M2