[ postfixadmin-Bugs-2967410 ] virtual list

[SourceForge.net <no...@so...>]

Bugs item #2967410, was opened at 2010-03-10 16:43
Message generated for change (Comment added) made by lory
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2967410&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Core
Group: v 2.3
Status: Open
Resolution: Wont Fix
Priority: 9
Private: No
Submitted By: Milorad Vasilev (lory)
Assigned to: Nobody/Anonymous (nobody)
Summary: virtual list

Initial Comment:
I have 100068 mailboxes in mailbox table.
when select this domain I see mysql select like this

| 19443 | postfix | localhost:52787 | postfix | Query   |    1 | Sorting result | SELECT mailbox.username FROM mailbox WHERE mailbox.domain='cablemail.bg' ORDER BY mailbox.username LIMIT 3180, 1 |

after a while

| 19443 | postfix | localhost:52787 | postfix | Query   |    1 | Sorting result | SELECT mailbox.username FROM mailbox WHERE mailbox.domain='cablemail.bg' ORDER BY mailbox.username LIMIT 3190, 1 |

and so like 100000, it is a long time.

Domain with 250 mailboxes work fine.

I think that is a problem with paging accounts and aliases.

Regards: M.Vasilev

----------------------------------------------------------------------

>Comment By: Milorad Vasilev (lory)
Date: 2010-03-11 10:11

Message:
Now I edit functions.inc.php and made thi changes
1.
//    if ( $list['alias_count'] > $page_size )
    if ( 0 )
2.
//    if ( $list['mailbox_count'] > $page_size )
    if ( 0 )

Now I havn't mailbox index like this:
:: Mailboxes  aa-am am-bi bk-bt ce-dd di-dp ds-er es-gk gm-im im-it it-kd
kd-ks kv-ma ma-mg mh-na na-no nt-pp pr-rm rr-rt rz-sk sk-ss sv-tl tm-vg
vh-vl vm-vv vv-zo zs-zt

But I can managed mailboxes and aliases.

Lory.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2967410&group_id=191583