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 "Tellier Benoit (JIRA)" <se...@james.apache.org> on 2017/05/29 01:44:04 UTC
[jira] [Commented] (JAMES-2037) Avoid reading messages when
building UID <=> MSN mapping upon SELECT
[ https://issues.apache.org/jira/browse/JAMES-2037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16027993#comment-16027993 ]
Tellier Benoit commented on JAMES-2037:
---------------------------------------
https://github.com/linagora/james-project/pull/812 is a proposal of implementation for this issue:
Bench used: SELECT 5000 non-RECENT messages (Aka already selected). This is mean time run on 10 SELECT. This is obtained after 5 runs for warm-up.
- Before state: **master** + **MAILBOX-297** (https://github.com/linagora/james-project/pull/806)
- After state: **master** + **MAILBOX-297** + this PR
Before results: ~ 1.07 seconds (mean 10 times)
After state: 103 ms (mean 10 times)
Basically: x10 improvement.
> Avoid reading messages when building UID <=> MSN mapping upon SELECT
> --------------------------------------------------------------------
>
> Key: JAMES-2037
> URL: https://issues.apache.org/jira/browse/JAMES-2037
> Project: James Server
> Issue Type: Improvement
> Reporter: Tellier Benoit
>
> SelectedMailboxImpl builds the UID <=> MSN mapping for later uses.
> Today, to do so, we read messages, and keep their UID.
> Needless to say, for some back-ends reading messages is an expensive operation requiring "soft joins" (Cassandra). We should offer a way to directly get an Iterator of UIDs in the mailbox.
> That would allow further optimizations, mostly on Cassandra implementations, avoid thousands of queries upon IMAP SELECT commands on large mailboxes.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org