james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Burrell Donkin (JIRA)" <server-...@james.apache.org>
Subject [jira] Updated: (JAMES-784) [jdbc] frequent full table scans on users table
Date Sat, 07 Apr 2007 10:59:32 GMT

     [ 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


Mime
View raw message