[GitHub] [couchdb] nickva edited a comment on issue #3517: Performance regression on CouchDB v3 while using custom reduce function

[GitBox <gi...@apache.org>]

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 and 2.3.1 on Ubuntu 20.04. For 3.x I installed the libmozjs185 couchdb-build package for Ubuntu 18.04 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
   ```
   
   Configure 3.x to build with version 1.8.5
   ```
   ./configure --spidermonkey-version 1.8.5 --dev
   ```
   
   Test was modified to not set up docker container.
   ```
   ./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
   ```
   
   


-- 
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: notifications-unsubscribe@couchdb.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org