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