Skip to content
Snippets Groups Projects
Select Git revision
  • move-gl-dropdown
  • improve-table-pagination-spec
  • move-markdown-preview
  • winh-fix-merge-request-spec
  • master default
  • index-namespaces-lower-name
  • winh-single-karma-test
  • 10-3-stable
  • 36782-replace-team-user-role-with-add_role-user-in-specs
  • winh-modal-internal-state
  • tz-ide-file-icons
  • 38869-milestone-select
  • update-autodevops-template
  • jivl-activate-repo-cookie-preferences
  • qa-add-deploy-key
  • docs-move-article-ldap
  • 40780-choose-file
  • 22643-manual-job-page
  • refactor-cluster-show-page-conservative
  • dm-sidekiq-versioning
  • v10.4.0.pre
  • v10.3.0
  • v10.3.0-rc5
  • v10.3.0-rc4
  • v10.3.0-rc3
  • v10.3.0-rc2
  • v10.2.5
  • v10.3.0-rc1
  • v10.0.7
  • v10.1.5
  • v10.2.4
  • v10.2.3
  • v10.2.2
  • v10.2.1
  • v10.3.0.pre
  • v10.2.0
  • v10.2.0-rc4
  • v10.2.0-rc3
  • v10.1.4
  • v10.2.0-rc2
40 results

diff

  • Clone with SSH
  • Clone with HTTPS
  • Forked from GitLab.org / GitLab FOSS
    Source project has a limited visibility.
    user avatar
    Yorick Peterse authored
    Performance is improved in two steps:
    
    1. On PostgreSQL an expression index is used for checking lower(email)
       and lower(username).
    2. The check to determine if we're searching for a username or Email is
       moved to Ruby. Thanks to @haynes for suggesting and writing the
       initial implementation of this.
    
    Moving the check to Ruby makes this method an additional 1.5 times
    faster compared to doing the check in the SQL query.
    
    With performance being improved I've now also tweaked the amount of
    iterations required by the User.by_login benchmark. This method now runs
    between 900 and 1000 iterations per second.
    72f428c7
    History
    Name Last commit Last update
    ..