(if necessary, information about the hardware should also be provided here.)
On our AS2 system, there are over 1.7 million (1,700,000) messages, there is a search for all messages that opens in a second (display the first 1,000 messages). If you want to search for indexed fields (for example, ComRef, Subject, …) then this takes less than one second (search with Starts with)
The display of all messages in the message basket (without filter by status, TaskState ..) takes <1 sec., While the message basket contains 970,000 messages.
The display of the same message basket filtered by status and TaskState takes slightly longer, at 3 sec. 1)