Specify folder by folder path
Prepare data
Create 100,000 Mailboxes
Create 100 Folders
Trigger
The impacts in a transaction
affect ESM
Batch process by mailboxes
Affect RPS
Create stored procedure to process mailboxes
Input a table with mailbox id
Compare the performance
100,000 mailboxes
1,000 mailboxes
10 mailboxes
cost of searching with folder path
Add an entry in folder table
Monitor the cost
Length of folder path value
Maximum of temp table
refer to outlook?
Usually used for 1000
Pre-insert to a persistent table
Temp table
Stored procedure or function