Hey Jan, Thanks a lot! That makes perfect sense and fully covers all the concerns I had. Exciting
Reddy 19 avr. 2022 14:09:53 Jan Lehnardt <j...@apache.org>: > Heya Reddy, > > there are no current plans to improve indexing performance by revising the > couchjs protocol. > > CouchDB gives you these options to speed up indexing, especially larger > databases: > > - increase the q value of your database[1]. Shard indexes are built in > parallel and this scales linearly with available CPU cores. > > - switch to Mango where possible. Mango is less expressive than views, so not > all can be migrated. There is some light movement in making mango more > expressive, but nothing definite is available at the moment[2]. > > > Finally, the CouchDB+FDB codebase includes a variant of views where indexes > are updated on write instead of on-read. I hope that this design, at least as > an opt-in features, makes its way to mainline CouchDB. Then you can trade-off > doc write time with index-build time. > > Given the nature of the couchjs implementation, I don’t see a lot of room for > substantially revamping the couchjs protocol. If we ever move to something > that gives us a more fully fledged programming environment, there are further > options. > > Best > Jan > — > > [1]: > https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.couchdb.org%2Fen%2F3.2.2%2Fcluster%2Fsharding.html%23splitting-shards&data=05%7C01%7C%7C9b8495e3cb6241becad008da21fd81db%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637859669930075804%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=pScmSo7jJlc6yTc%2Bm4mbON98vSP66cN%2FHKIfgDynxDY%3D&reserved=0 > [2]: > https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fapache%2Fcouchdb%2Fpull%2F3912&data=05%7C01%7C%7C9b8495e3cb6241becad008da21fd81db%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637859669930075804%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=V9RGwsZIlUI3i1GIggxY6txqTm%2FKLZdf61xgjIFXPbo%3D&reserved=0 > — > Professional Support for Apache CouchDB: > https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fneighbourhood.ie%2Fcouchdb-support%2F&data=05%7C01%7C%7C9b8495e3cb6241becad008da21fd81db%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637859669930075804%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=B%2FPAJNVwy5mDPmhlfZI5znSsWTz4AgGxEcBRKvZFnC8%3D&reserved=0 > > 24/7 Observation for your CouchDB Instances: > https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fopservatory.app%2F&data=05%7C01%7C%7C9b8495e3cb6241becad008da21fd81db%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637859669930544510%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=0XuF0kpVbF5tm%2FPzDXtLti2k86GKCuRNOwep%2FozI7jA%3D&reserved=0 > >> On 19. Apr 2022, at 13:03, Reddy B. <redd...@live.fr> wrote: >> >> Hello, >> >> Is there currently an effort to improve the indexing performance of >> map/reduce javascript views? I have this issue in >> mind.[https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fissues.apache.org%2Fjira%2Fbrowse%2FCOUCHDB-1743&data=05%7C01%7C%7C9b8495e3cb6241becad008da21fd81db%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637859669930544510%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=5IGfzQMTe98QdF2FOdwg7XK9jriKjEAzToQAPFrPxPI%3D&reserved=0] >> >> Improving the indexing performance on very large databases (hundreds of >> millions of documents) would be strategic. >> >> What is the current consensus on this question? have a decision been made >> that users should use mango moving forward, or would work related to the >> proposal brought in the aforementionned issue be welcome? >> >> Best, >> >> Reddy