Re: Database denormalization

2013-01-10 Thread Alexandre Rafalovitch
On Thu, Jan 10, 2013 at 9:37 AM, Bruno Dusausoy wrote: > Have you tried inverting the order of your nested entities (organ as an >> outer one, etc) and seeing if that's better for your needs? >> >> Interesting idea, never thought about that. > But unfortunately my real case is much much more com

Re: Database denormalization

2013-01-10 Thread Bruno Dusausoy
Alexandre Rafalovitch a écrit : Not sure if I fully understood that, but it seems to be that you are currently indexing "file" with extra child info, when you want to be indexing "organs" with extra parent info. Given that File with file_ref = 1, it has two procedures : - proc_ref = 1, - proc_r

Re: Database denormalization

2013-01-10 Thread Alexandre Rafalovitch
Not sure if I fully understood that, but it seems to be that you are currently indexing "file" with extra child info, when you want to be indexing "organs" with extra parent info. Have you tried inverting the order of your nested entities (organ as an outer one, etc) and seeing if that's better fo

Database denormalization

2013-01-10 Thread Bruno Dusausoy
Hi, I'm quite new with Solr. I've searched for this but found no answer to my needs, which seems to be quite common though. Let's say I have three entities in my database (I have more than that but it's for the sake of simplicity) : File *--* Procedure *--* Organ 1 n