Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-19384

Adding an index on ezuser.login could lead to substancial performance gains.

    XMLWordPrintable

Details

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Medium Medium
    • None
    • 4.3.0, 4.4.0, 4.5.0, 4.6.0
    • Misc
    • None

    • eZ Publish 4.3

    Description

      On an environment with a very large number of users, adding an index to the ezuser table, 'login' field, can lead to substancial performance gains.

      With around 400k users and content objects, a JOIN query in eZUser::_loginUser() finishes in 0,01 s with the index, and 0,93 s without it.

      Attachments

        Activity

          People

            e8318ba6-e4ae-477c-9116-36c073bd11a3@accounts.ibexa.co Patrick Allaert
            ji@ez.no ji@ez.no
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: