Please enable JavaScript.
Coggle requires JavaScript to display documents.
Specify folder by folder path (Batch process by mailboxes (Compare the…
Specify folder by folder path
Prepare data
Create 100,000 Mailboxes
Create 100 Folders
Trigger
The impacts in a transaction
Add an entry in folder table
Monitor the cost
affect ESM
cost of searching with folder path
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
Length of folder path value
refer to outlook?
Usually used for 1000
Maximum of temp table
Pre-insert to a persistent table
Temp table
Stored procedure or function