konrad-ohms commented on issue #3517:
URL: https://github.com/apache/couchdb/issues/3517#issuecomment-915121820
Thanks @janl, I compiled your PR and ran the test suite again.
Unfortunately, the second fix in the PR is not performing as good as the
prior patch, but it is still better than the original 3.1.1 performance.
| Version | Average Performance |
|--------------------------|---------------------|
| 3.1.1 | 36.43s |
| 3.1.1 patch 1 | 11.45s |
| 3.1.1 patch 2 (PR #3728) | 25.25s |
Please find my full result output below:
```bash
$ ./couchdb-test.sh query
CouchDB performance regression test script
Assuming that setup is already complete
================ Query CouchDB 3.1.1 ================
{"couchdb":"Welcome","version":"3.1.1","git_sha":"ce596c65d","uuid":"ae7c1c70f02a0b873d0a4f414e1a4d7e","features":["access-ready","partitioned","pluggable-storage-engines","reshard","scheduler"],"vendor":{"name":"The
Apache Software Foundation"}}
Query Database views on port 3003
Round: 1/10
real 0m35.155s
user 0m0.019s
sys 0m0.014s
Round: 2/10
real 0m35.645s
user 0m0.011s
sys 0m0.015s
Round: 3/10
real 0m37.915s
user 0m0.008s
sys 0m0.018s
Round: 4/10
real 0m36.850s
user 0m0.008s
sys 0m0.018s
Round: 5/10
real 0m35.977s
user 0m0.016s
sys 0m0.012s
Round: 6/10
real 0m36.915s
user 0m0.010s
sys 0m0.016s
Round: 7/10
real 0m35.969s
user 0m0.010s
sys 0m0.017s
Round: 8/10
real 0m37.248s
user 0m0.014s
sys 0m0.013s
Round: 9/10
real 0m36.506s
user 0m0.013s
sys 0m0.012s
Round: 10/10
real 0m36.101s
user 0m0.012s
sys 0m0.014s
================ Query CouchDB 3.1.1 patch jan ================
{"couchdb":"Welcome","version":"3.1.1","git_sha":"6c2d01a","uuid":"54f521952cafc33bdb70987c4fc6cd69","features":["access-ready","partitioned","pluggable-storage-engines","reshard","scheduler"],"vendor":{"name":"The
Apache Software Foundation"}}
Query Database views on port 3004
Round: 1/10
real 0m11.213s
user 0m0.015s
sys 0m0.010s
Round: 2/10
real 0m11.737s
user 0m0.008s
sys 0m0.017s
Round: 3/10
real 0m11.524s
user 0m0.013s
sys 0m0.012s
Round: 4/10
real 0m11.387s
user 0m0.011s
sys 0m0.014s
Round: 5/10
real 0m11.257s
user 0m0.013s
sys 0m0.011s
Round: 6/10
real 0m11.325s
user 0m0.012s
sys 0m0.013s
Round: 7/10
real 0m11.846s
user 0m0.012s
sys 0m0.013s
Round: 8/10
real 0m11.652s
user 0m0.009s
sys 0m0.015s
Round: 9/10
real 0m11.508s
user 0m0.013s
sys 0m0.012s
Round: 10/10
real 0m11.351s
user 0m0.015s
sys 0m0.010s
================ Query CouchDB 3.1.1 patch2 jan ================
{"couchdb":"Welcome","version":"3.1.1","git_sha":"65fd7ec","uuid":"73454c85dfb63b0826f42e25310b6dec","features":["access-ready","partitioned","pluggable-storage-engines","reshard","scheduler"],"vendor":{"name":"The
Apache Software Foundation"}}
Query Database views on port 3005
Round: 1/10
real 0m25.617s
user 0m0.017s
sys 0m0.011s
Round: 2/10
real 0m25.098s
user 0m0.014s
sys 0m0.015s
Round: 3/10
real 0m24.765s
user 0m0.010s
sys 0m0.015s
Round: 4/10
real 0m26.233s
user 0m0.010s
sys 0m0.016s
Round: 5/10
real 0m25.144s
user 0m0.011s
sys 0m0.016s
Round: 6/10
real 0m25.586s
user 0m0.015s
sys 0m0.012s
Round: 7/10
real 0m24.918s
user 0m0.013s
sys 0m0.014s
Round: 8/10
real 0m24.787s
user 0m0.011s
sys 0m0.015s
Round: 9/10
real 0m25.519s
user 0m0.015s
sys 0m0.011s
Round: 10/10
real 0m24.812s
user 0m0.014s
sys 0m0.011s
```
--
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]
