Do you have an idea on performance when talking about hundreds of thousands resources in the db and thousands related to the subject in question. I know this will be highly implementation specific but what I'm trying to understand is if this is a viable solution at thie scale I described