1. Flatten the data into a single table. 2. Solr does not seem like a good solution for order data, especially live orders that need to be transactional. That is a great match to a standard relational DB.
wunder On Nov 30, 2013, at 12:15 AM, subacini Arunkumar <subac...@gmail.com> wrote: > Hi > > We are using solr 4.4 . Please let me know the possible solutions to > address my requirement. > > We have to fetch data from two tables Product , Order table. > > Product Table > > id Name > P1 ipad > P2 iphone 4 > P3 iphone 5 > > > Order Table > > id order date product_id > O1 1-Dec-2012 P1 > O2 1-Dec-2012 P2 > O3 2-Dec-2012 P2 > > I want to show the details in UI as below > > O1 01-Dec-2012 > > > On Sat, Nov 30, 2013 at 12:13 AM, subacini Arunkumar > <subac...@gmail.com>wrote: > >> Hi >> >> We are using solr 4.4 . Please let me know the possible solutions to >> address my requirement. >> >> We have to fetch data from two tables Product , Order table. >> >> Product Table >> >> id Name >> P1 ipad >> P2 iphone 4 >> P3 iphone 5 >> >> >> Order Table >> >> id order date product_id >> O1 >> >> -- Walter Underwood wun...@wunderwood.org
