vttranlina commented on PR #1858:
URL: https://github.com/apache/james-project/pull/1858#issuecomment-1862119407
The first performance test looks not good.
The KO result is better, but the 99th is not.
## Env
Local.
Sample: `select count(*) from message_mailbox;` = 566904
Before the test, I created a sample user_flags by query
```sql
UPDATE message_mailbox
SET user_flags = (
SELECT ARRAY(SELECT 'sample_data_' || generate_series(1, 50)::text)
) where 1=1
returning user_flags;
```
I also modify the Gatling scenario for increase the update flags request.
You can see: `singleFlagsAdd`, `rangeFlagsAdd`, `singleFlagsRemove`,
`rangeFlagsRemove`
https://github.com/linagora/james-gatling/commit/be38ae6730e1e4df085e5ef300de2da65dd169d1
Gatling
```
export DURATION=20
export USER_COUNT=5000
```
Result:

--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]