You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by "Robert Burrell Donkin (JIRA)" <se...@james.apache.org> on 2007/04/07 12:57:32 UTC

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

[jdbc] frequent full table scans on users table
-----------------------------------------------

                 Key: JAMES-784
                 URL: https://issues.apache.org/jira/browse/JAMES-784
             Project: James
          Issue Type: Task
          Components: UsersStore & UsersRepository
            Reporter: Robert Burrell Donkin
         Assigned To: Robert Burrell Donkin
            Priority: Minor


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


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

Posted by "Robert Burrell Donkin (JIRA)" <se...@james.apache.org>.
     [ https://issues.apache.org/jira/browse/JAMES-784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Robert Burrell Donkin updated JAMES-784:
----------------------------------------

    Attachment: user-sql.cost

Derby log giving cost for query

> [jdbc] frequent full table scans on users table
> -----------------------------------------------
>
>                 Key: JAMES-784
>                 URL: https://issues.apache.org/jira/browse/JAMES-784
>             Project: James
>          Issue Type: Task
>          Components: UsersStore & UsersRepository
>            Reporter: Robert Burrell Donkin
>         Assigned To: 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


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

Posted by "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