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? >
