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
