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:
   
![updateFlagConcurrency](https://github.com/apache/james-project/assets/81145350/43b48939-71d8-490e-ab56-7ffef94bdb1f)
   


-- 
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]

Reply via email to