On 17 June 2013 21:39, Mysurf Mail <stammail...@gmail.com> 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 indexing the data into Solr, and does the performance not meet your needs, or are you guessing from the size of the tables? > Lets consider the following example scenario > > My Tables are > > School > Students (1:n with school) > Teachers(1:n with school) [...] Um, all of this crucially depends on what your 'n' is. Plus, you need to describe your use case in much more detail. At the moment, you are asking us to guess at what you are trying to do, which is inefficient, and unlikely to solve your problem. Regards, Gora
