Thank you Jan, Vincezo and Joe. This helps us a lot. On Mon, May 11, 2020 at 10:03 PM Joe Obernberger < joseph.obernber...@gmail.com> wrote:
> Could you use a multi-valued field for user in each of your products? > > So productA and a field User that is a list of all the users that have > productA. Then you could do a search like: > > user:User1 AND Product_A_cost:[5 TO 10] > user:(User1 User5...) AND Product_B_cost[0 TO 40] > > -Joe > > On 5/11/2020 5:35 AM, Vignan Malyala wrote: > > I have around 1M products used by my clients. > > Client need a filter of these 1M products by their cost filters. > > > > Just like: > > User1 has 5 products (A,B,C,D,E) > > User2 has 3 products (D,E,F) > > User3 has 10 products (A,B,C,H,I,J,K,L,M,N,O) > > > > ...every customer has different sets. > > > > Now they want to search users by filter of product costs: > > Product_A_cost : 50 TO 100 > > Product_D_cost : 0 TO 40 > > > > it should return all the users who use products in this filter range. > > > > As I have 1M products, do I need to create dynamic fields for all users > > with filed names as Product_A_cost and product_B_cost..... etc to make a > > search by them? If I should, then I haveto create 1M dynamic fields > > Or is there any other way? > > > > Hope I'm clear here! > > > > > > On Mon, May 11, 2020 at 1:47 PM Jan Høydahl <jan....@cominvent.com> > wrote: > > > >> Sounds like an anti pattern. Can you explain what search problem you are > >> trying to solve with this many unique fields? > >> > >> Jan Høydahl > >> > >>> 11. mai 2020 kl. 07:51 skrev Vignan Malyala <dsmsvig...@gmail.com>: > >>> > >>> Hi > >>> Is it good idea to create 100000 dynamic fields of time pint in solr? > >>> I have that many fields to search on actually which come upon based on > >>> users. > >>> > >>> Thanks in advance! > >>> And I'm using Solr Cloud in real-time. > >>> > >>> Regards, > >>> Sai Vignan M > > >
