[ postfixadmin-Bugs-2967410 ] virtual list

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

Bugs item #2967410, was opened at 2010-03-10 16:43
Message generated for change (Tracker Item Submitted) 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: None
Priority: 5
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

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

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