Re: How to define my data in schema.xml

2013-06-19 Thread Mysurf Mail
3 9:58 AM > > To: solr-user@lucene.apache.org > Subject: Re: How to define my data in schema.xml > > Hi Jack, > Thanks, for you kind comment. > > I am truly in the beginning of data modeling my schema over an existing > working DB. > I have used the school-teachers-stude

Re: How to define my data in schema.xml

2013-06-18 Thread Jack Krupansky
@lucene.apache.org Subject: Re: How to define my data in schema.xml Hi Jack, Thanks, for you kind comment. I am truly in the beginning of data modeling my schema over an existing working DB. I have used the school-teachers-student db as an example scenario. (a, I have written it as a disclaimer in my

Re: How to define my data in schema.xml

2013-06-18 Thread Mysurf Mail
organized to > satisfy those user queries. > > -- Jack Krupansky > > -----Original Message- From: Mysurf Mail > Sent: Tuesday, June 18, 2013 2:20 AM > To: solr-user@lucene.apache.org > Subject: Re: How to define my data in schema.xml > > > Thanks for your reply

Re: How to define my data in schema.xml

2013-06-18 Thread Jack Krupansky
hat will guide you in thinking about how the data would need to be organized to satisfy those user queries. -- Jack Krupansky -Original Message- From: Mysurf Mail Sent: Tuesday, June 18, 2013 2:20 AM To: solr-user@lucene.apache.org Subject: Re: How to define my data in schema.xml Tha

Re: How to define my data in schema.xml

2013-06-17 Thread Mysurf Mail
Thanks for your reply. I have tried the simplest approach and it works absolutely fantastic. Huge table - 0s to result. two problems as I described earlier, and that is what I try to solve: 1. I create a flat table just for solar. This requires maintenance and develop. Can I run solr over my regul

Re: How to define my data in schema.xml

2013-06-17 Thread Gora Mohanty
On 18 June 2013 01:10, Mysurf Mail wrote: > Thanks for your quick reply. Here are some notes: > > 1. Consider that all tables in my example have two columns: Name & > Description which I would like to index and search. > 2. I have no other reason to create flat table other than for solar. So I > w

Re: How to define my data in schema.xml

2013-06-17 Thread Mysurf Mail
Thanks for your quick reply. Here are some notes: 1. Consider that all tables in my example have two columns: Name & Description which I would like to index and search. 2. I have no other reason to create flat table other than for solar. So I would like to see if I can avoid it. 3. If in my exampl

Re: How to define my data in schema.xml

2013-06-17 Thread Gora Mohanty
On 17 June 2013 21:39, Mysurf Mail wrote: > Hi, > I have created a flat table from my DB and defined a solr core on it. > It works excellent so far. > > My problem is that my table has two hierarchies. So when flatted it is too > big. What do you mean by "too big"? Have you actually tried indexin