[jira] Resolved: (JAMES-784) [jdbc] frequent full table scans on users table

["Norman Maurer (JIRA)" <se...@james.apache.org>]

     [ https://issues.apache.org/jira/browse/JAMES-784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Norman Maurer resolved JAMES-784.
---------------------------------

    Resolution: Won't Fix

JDBCUsersRepository is @deprecated. JPAUsersRepository is the way to go and comes with an index.

> [jdbc] frequent full table scans on users table
> -----------------------------------------------
>
>                 Key: JAMES-784
>                 URL: https://issues.apache.org/jira/browse/JAMES-784
>             Project: JAMES Server
>          Issue Type: Task
>          Components: UsersStore & UsersRepository
>            Reporter: Robert Burrell Donkin
>            Assignee: Robert Burrell Donkin
>            Priority: Minor
>         Attachments: user-sql.cost
>
>
> Users are looked up by name on the users table but this column lacks an index. Should add index.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org