Mailing List Archive

SORT Problem - OpenGroupware
I tried a larger mailbox in OpenGroupware. It is way tooooo slow....

It takes 8-10 seconds for a mailbox 200 messages. Cyrus does it instantaneously. It makes sense. OpenGroupware does not have a local repository (just as SquirrelMail does not - or any other web mail program).

Folks, the SORT problem seems to be a show stopper for web mail implementations. I cant imagine this would be difficult to implement. Ultimately it is an ORDER BY on the SQL statement. I dont know what is involved on the IMAP side.

This does not appear to be a big deal for Outlook/Express since they have local repositories and sorts can be done locally efficiently.


---------------------------------
Do you Yahoo!?
Yahoo! Search - Find what you’re looking for faster.
Re: SORT Problem - OpenGroupware [ In reply to ]
This observation was made before :)

SORT and THREAD will have to be implemented for version 2.1

Ilja


Sanjiv Bawa wrote:

> I tried a larger mailbox in OpenGroupware. It is way tooooo slow....
>
> It takes 8-10 seconds for a mailbox 200 messages. Cyrus does it
> instantaneously. It makes sense. OpenGroupware does not have a local
> repository (just as SquirrelMail does not - or any other web mail program).
>
> Folks, the SORT problem seems to be a show stopper for web mail
> implementations. I cant imagine this would be difficult to implement.
> Ultimately it is an ORDER BY on the SQL statement. I dont know what is
> involved on the IMAP side.
>
> This does not appear to be a big deal for Outlook/Express since they
> have local repositories and sorts can be done locally efficiently.
>
> Do you Yahoo!?
> Yahoo! Search - Find what you’re looking for faster.
> <http://search.yahoo.com/?fr=ad-mailsig-home>
Re: SORT Problem - OpenGroupware [ In reply to ]
> This observation was made before :)
>
> SORT and THREAD will have to be implemented for version 2.1

Or as a patch to 2.0 if I can get it done shortly, I really need it for
our application which is a web based mail desktop system. So my client is
asking for this almost every day. I hope to have something by next week:)

-leif

>
> Ilja
>
>
> Sanjiv Bawa wrote:
>
>> I tried a larger mailbox in OpenGroupware. It is way tooooo slow....
>>
>> It takes 8-10 seconds for a mailbox 200 messages. Cyrus does it
>> instantaneously. It makes sense. OpenGroupware does not have a local
>> repository (just as SquirrelMail does not - or any other web mail
>> program).
>>
>> Folks, the SORT problem seems to be a show stopper for web mail
>> implementations. I cant imagine this would be difficult to implement.
>> Ultimately it is an ORDER BY on the SQL statement. I dont know what is
>> involved on the IMAP side.
>>
>> This does not appear to be a big deal for Outlook/Express since they
>> have local repositories and sorts can be done locally efficiently.
>>
>> Do you Yahoo!?
>> Yahoo! Search - Find what you’re looking for faster.
>> <http://search.yahoo.com/?fr=ad-mailsig-home>
> _______________________________________________
> Dbmail-dev mailing list
> Dbmail-dev@dbmail.org
> http://twister.fastxs.net/mailman/listinfo/dbmail-dev
>
Re: SORT Problem - OpenGroupware [ In reply to ]
Yay!!! You are a life saver Leif.

SB

Leif Jackson <ljackson@jjcons.com> wrote:
> This observation was made before :)
>
> SORT and THREAD will have to be implemented for version 2.1

Or as a patch to 2.0 if I can get it done shortly, I really need it for
our application which is a web based mail desktop system. So my client is
asking for this almost every day. I hope to have something by next week:)

-leif

>
> Ilja
>
>
> Sanjiv Bawa wrote:
>
>> I tried a larger mailbox in OpenGroupware. It is way tooooo slow....
>>
>> It takes 8-10 seconds for a mailbox 200 messages. Cyrus does it
>> instantaneously. It makes sense. OpenGroupware does not have a local
>> repository (just as SquirrelMail does not - or any other web mail
>> program).
>>
>> Folks, the SORT problem seems to be a show stopper for web mail
>> implementations. I cant imagine this would be difficult to implement.
>> Ultimately it is an ORDER BY on the SQL statement. I dont know what is
>> involved on the IMAP side.
>>
>> This does not appear to be a big deal for Outlook/Express since they
>> have local repositories and sorts can be done locally efficiently.
>>
>> Do you Yahoo!?
>> Yahoo! Search - Find what you’re looking for faster.
>>
> _______________________________________________
> Dbmail-dev mailing list
> Dbmail-dev@dbmail.org
> http://twister.fastxs.net/mailman/listinfo/dbmail-dev
>

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
Re: SORT Problem - OpenGroupware [ In reply to ]
Leif,

From the RFC it does not appear that SORT will be too hard to implement. THREAD appears to be much more hairy. I will be happy to help testing SORT if you can get it written. I am not familiar with the code at all....

Thanks.

SB

Leif Jackson <ljackson@jjcons.com> wrote:
> This observation was made before :)
>
> SORT and THREAD will have to be implemented for version 2.1

Or as a patch to 2.0 if I can get it done shortly, I really need it for
our application which is a web based mail desktop system. So my client is
asking for this almost every day. I hope to have something by next week:)

-leif

>
> Ilja
>
>
> Sanjiv Bawa wrote:
>
>> I tried a larger mailbox in OpenGroupware. It is way tooooo slow....
>>
>> It takes 8-10 seconds for a mailbox 200 messages. Cyrus does it
>> instantaneously. It makes sense. OpenGroupware does not have a local
>> repository (just as SquirrelMail does not - or any other web mail
>> program).
>>
>> Folks, the SORT problem seems to be a show stopper for web mail
>> implementations. I cant imagine this would be difficult to implement.
>> Ultimately it is an ORDER BY on the SQL statement. I dont know what is
>> involved on the IMAP side.
>>
>> This does not appear to be a big deal for Outlook/Express since they
>> have local repositories and sorts can be done locally efficiently.
>>
>> Do you Yahoo!?
>> Yahoo! Search - Find what you’re looking for faster.
>>
> _______________________________________________
> Dbmail-dev mailing list
> Dbmail-dev@dbmail.org
> http://twister.fastxs.net/mailman/listinfo/dbmail-dev
>

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
Re: SORT Problem - first patch for sort command ***VERY ALPHA*** [ In reply to ]
ALl,

Well people, attached is the first attempt, this code works for the SORT
options required for my customers webmail system it will need some
enhancment to fully follow the rfc draft for the SORT extention, It does
subject,to,cc,from and arrival. Arrival was the easiest so it works
perfectly, the others involved a new merge sort I added to list.c and
obviously pulling all the headers in a mailbox which blows as far as
performance. I would like to warn everyone while this code works it is no
where near ready to go into any environment without a lot more help. But
I needed to get it going so here it is.

Please feel free to help/give comments and sugestions. For this first
version I used a high perfomance merge sort I found with a relativly
compatible grant on the licence. If anyone has a singly-link list merge
sort or other better performing sort that is compatiable with the list.c
code I would like to see options.

A requirment for the sorting of header fields is the header caching I
don't see this working with any kind of speed without it.

Thanks,
Leif

p.s. a sample of the sort commands I used for testing would be....

A001 LOGIN "username" "password"
A002 select "INBOX"
A003 SORT (ARRIVAL) ISO-8859-1 ALL


p.p.s. see
http://www.ietf.org/internet-drafts/draft-ietf-imapext-sort-14.txt



> Yay!!! You are a life saver Leif.
>
> SB
>
> Leif Jackson <ljackson@jjcons.com> wrote:
>> This observation was made before :)
>>
>> SORT and THREAD will have to be implemented for version 2.1
>
> Or as a patch to 2.0 if I can get it done shortly, I really need it for
> our application which is a web based mail desktop system. So my client is
> asking for this almost every day. I hope to have something by next week:)
>
> -leif
>
>>
>> Ilja
>>
>>
>> Sanjiv Bawa wrote:
>>
>>> I tried a larger mailbox in OpenGroupware. It is way tooooo slow....
>>>
>>> It takes 8-10 seconds for a mailbox 200 messages. Cyrus does it
>>> instantaneously. It makes sense. OpenGroupware does not have a local
>>> repository (just as SquirrelMail does not - or any other web mail
>>> program).
>>>
>>> Folks, the SORT problem seems to be a show stopper for web mail
>>> implementations. I cant imagine this would be difficult to implement.
>>> Ultimately it is an ORDER BY on the SQL statement. I dont know what is
>>> involved on the IMAP side.
>>>
>>> This does not appear to be a big deal for Outlook/Express since they
>>> have local repositories and sorts can be done locally efficiently.
>>>
>>> Do you Yahoo!?
>>> Yahoo! Search - Find what you’re looking for faster.
>>>
>> _______________________________________________
>> Dbmail-dev mailing list
>> Dbmail-dev@dbmail.org
>> http://twister.fastxs.net/mailman/listinfo/dbmail-dev
>>
>
> _______________________________________________
> Dbmail-dev mailing list
> Dbmail-dev@dbmail.org
> http://twister.fastxs.net/mailman/listinfo/dbmail-dev
> Do you Yahoo!?
> Yahoo! Mail - More reliable, more storage, less
> spam_______________________________________________
> Dbmail-dev mailing list
> Dbmail-dev@dbmail.org
> http://twister.fastxs.net/mailman/listinfo/dbmail-dev
>