I don't know if it was the merit of this mailing list, but the bad debt has been paid right now, you can ignore my previous comment now!
-------------------------- *Alessandro Benedetti* Director @ Sease Ltd. *Apache Lucene/Solr Committer* *Apache Solr PMC Member* e-mail: a.benede...@sease.io *Sease* - Information Retrieval Applied Consulting | Training | Open Source Website: Sease.io <http://sease.io/> LinkedIn <https://linkedin.com/company/sease-ltd> | Twitter <https://twitter.com/seaseltd> | Youtube <https://www.youtube.com/channel/UCDx86ZKLYNpI3gzMercM7BQ> | Github <https://github.com/seaseltd> On Tue, 8 Aug 2023 at 13:34, Alessandro Benedetti <a.benede...@sease.io> wrote: > As a community how should we behave with gentlemen that didn't pay their > suppliers for their services and then come here? > > As an Apache Lucene/Solr committer I very commonly use the funds I receive > from my clients (for my services) to sponsor my and my colleague's > contributions. > > This company has a long overdue debit with my company and stop responding. > At the same time is looking for free advise on the mailing list for the > same project... > I find this very unrespectful... > > On Tue, 8 Aug 2023, 08:22 Vishal Patel, <vishalpatel199...@outlook.com> > wrote: > >> We are using Solr 8.9.0. We have configured Solr cloud like 2 shards and >> each shard has one replica. We have used 5 zoo keepers for Solr cloud. >> We have created 2 collections 1) forms 2) actionscomments >> Schema field of forms >> <field name="id" type="string" indexed="true" stored="true" >> required="true" multiValued="false" docValues="true"/> >> <field name="form_id" type="tint" indexed="true" stored="true" >> docValues="true"/> >> <field name="form_title" type="string" indexed="true" stored="true" >> omitNorms="true" omitTermFreqAndPositions="true"/> >> <field name="form_creation_date" type="date" indexed="true" stored="true" >> docValues="true"/> >> other fields ... >> >> Schema field of actionscomments >> <field name="id" type="string" indexed="true" stored="true" >> required="true" multiValued="false" docValues="true"/> >> <field name="project_id" type="tint" indexed="true" stored="true" >> docValues="true"/> >> <field name="form_id" type="tint" indexed="true" stored="true" >> docValues="true"/> >> <field name="action_id" type="tint" indexed="true" stored="true"/> >> <field name="action_date" type="date" indexed="true" stored="true" >> docValues="true"/> >> <field name="action_name" type="text_string" indexed="true" stored="true" >> omitNorms="true" omitTermFreqAndPositions="true"/> >> <field name="user" type="tint" indexed="true" stored="true"/> >> other fields ... >> >> Here one to many relationship between forms and actionscomments >> collections. >> There are 30 million records in forms collection and 700 million records >> in actionscomments. We are showing columns >> form_title,form_creation_date,action_name in form listing. We have given >> sorting in all columns. >> If any user set sort on action_name then we are getting records as below >> - First get all form_ids of that user from actionscomments collection >> with sorting of action_name. >> - Appending above form ids with boosting in query to get the forms data. >> >> Please note that we set score to 1 for all documents while indexing hence >> we used boost query. >> >> Example: >> >> actionscomments: >> Query: user:(713073) AND entity_type:(1) AND project_id:(2076645) sort >> field=action_name >> >> Query: ((doctype:Apps AND appType:1 AND is_formtype_active:true AND >> (is_draft:false OR msg_type_id:1) AND instance_group_id:(2313622) AND >> project_id:(2076645))) AND msg_id:(10130987^2 10139990^1 *)^20 >> >> It is taking more time to return the result. >> >> Is there any approach where we can get join and sort between two >> collection in cloud mode? >> >
