nickva edited a comment on issue #3517:
URL: https://github.com/apache/couchdb/issues/3517#issuecomment-890372099
I confirmed that the JS engine is implicated. I ran 2.3.1 and 3.x latest on
Ubuntu 20.04. For 3.x I installed the libmozjs185 couchdb-build package for
Ubuntu 18.04 on my Ubuntu 20.04 system and ran with q=8 to minimize difference
and similar performance numbers as 2.3.1.
Packages I downloaded and installed manually:
```
couch-libmozjs185-1.0_1.8.5-1.0.0+couch-2_bionic_amd64.deb
couch-libmozjs185-dev_1.8.5-1.0.0+couch-2_bionic_amd64.deb
libffi6_3.2.1-8_amd64.deb
libffi-dev_3.2.1-8_amd64.deb
```
(libffi6 was needed as a dependency of couch-libmozjs185)
Configure 3.x to build with version 1.8.5
```
./configure --spidermonkey-version 1.8.5 --dev
```
Test script was modified to not set up docker containers, just run locally
with 2.3.1 and 3.1.1 running on different ports.
```
./couchdb-test.sh query
CouchDB performance regression test script
Assuming that setup is already complete
================ Query CouchDB 2.3.1 ================
{"couchdb":"Welcome","version":"2.3.1","git_sha":"c298091a4","uuid":"fake_uuid_for_dev","features":["pluggable-storage-engines","scheduler"],"vendor":{"name":"The
Apache Software Foundation"}}
Query Database views on port 15994
Round: 1/10
real 0m13.022s
user 0m0.023s
sys 0m0.023s
Round: 2/10
real 0m7.234s
user 0m0.020s
sys 0m0.008s
Round: 3/10
real 0m6.715s
user 0m0.026s
sys 0m0.000s
Round: 4/10
real 0m7.021s
user 0m0.018s
sys 0m0.009s
Round: 5/10
real 0m7.159s
user 0m0.005s
sys 0m0.021s
Round: 6/10
real 0m7.318s
user 0m0.014s
sys 0m0.014s
Round: 7/10
real 0m7.464s
user 0m0.007s
sys 0m0.021s
Round: 8/10
real 0m7.175s
user 0m0.016s
sys 0m0.011s
Round: 9/10
real 0m7.096s
user 0m0.004s
sys 0m0.023s
Round: 10/10
real 0m7.235s
user 0m0.006s
sys 0m0.022s
```
```
q=8
================ Query CouchDB 3.1.1 ================
{"couchdb":"Welcome","version":"3.1.1-ba63878","git_sha":"ba63878","uuid":"fake_uuid_for_dev","features":["access-ready","partitioned","pluggable-storage-engines","reshard","scheduler"],"vendor":{"name":"The
Apache Software Foundation"}}
Query Database views on port 15984
Round: 1/10
real 0m5.979s
user 0m0.017s
sys 0m0.010s
Round: 2/10
real 0m6.757s
user 0m0.013s
sys 0m0.013s
Round: 3/10
real 0m7.112s
user 0m0.012s
sys 0m0.016s
Round: 4/10
real 0m7.359s
user 0m0.017s
sys 0m0.011s
Round: 5/10
real 0m7.210s
user 0m0.017s
sys 0m0.013s
Round: 6/10
real 0m7.233s
user 0m0.008s
sys 0m0.021s
Round: 7/10
real 0m6.284s
user 0m0.028s
sys 0m0.000s
Round: 8/10
real 0m7.101s
user 0m0.020s
sys 0m0.008s
Round: 9/10
real 0m6.943s
user 0m0.022s
sys 0m0.006s
Round: 10/10
real 0m6.736s
user 0m0.016s
sys 0m0.011s
```
With default mozjs68 library on Ubuntu I was getting around 30 seconds
--
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]
