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 regular tables?
This is my simplest approach. Working over my relational tables,
2. When you query a flat table by school name, as I described, if the
school has 300 student, 300 teachers, 300 with 300 teacherCourses, 300
studentHobbies,
you get 8.1 Billion rows (300*300*300*300). As I am sure this will work
great on solar - searching for the school name will retrieve 8.1 B rows.
3. Lets say all my searches are user generated free text search that is
searching name and comments columns.
Thanks.
On Tue, Jun 18, 2013 at 7:32 AM, Gora Mohanty <g...@mimirtech.com> wrote:
> On 18 June 2013 01:10, Mysurf Mail <stammail...@gmail.com> 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
> > would like to see if I can avoid it.
> > 3. If in my example I will have a flat table then obviously it will hold
> a
> > lot of rows for a single school.
> > By searching the exact school name I will likely receive a lot of
> rows.
> > (my flat table has its own pk)
>
> Yes, all of this is definitely the case, but in practice
> it does not matter. Solr can efficiently search through
> millions of rows. To start with, just try the simplest
> approach, and only complicate things as and when
> needed.
>
> > That is something I would like to avoid and I thought I can avoid
> this
> > by defining teachers and students as multiple value or something like
> this
> > and than teacherCourses and studentHobbies as 1:n respectively.
> > This is quite similiar to my real life demand, so I came here to get
> > some tips as a solr noob.
>
> You have still not described what are the searches that
> you would want to do. Again, I would suggest starting
> with the most straightforward approach.
>
> Regards,
> Gora
>
