http://codebetter.com/blogs/david.hayden/archive/20...cenarios.aspx

Nice!!?? hehe. Thanks for the link.

Amazing, isn't it? the performance is really terrible in that engine in these scenarios. I also don't get it. Why on earth would ANYONE want to fetch a graph with lazy loading. It's the most silly way of fetching a graph if you know up front which elements you need to fetch per node!

Also the excuse of the joins getting too complex is moot. Sure if you join another node to it it will become a big resultset, but that thus means you are on the wrong track and have to use a different fetch strategy. Apparently they don't want to do that, which is IMHO silly, because now they advertise as if they can fetch graphs efficiently, but that's a lie: most graphs will be terribly inefficient and people will only find out at runtime.

But... I shouldn't complain

ScottGu replied...

Kris wrote:

ScottGu replied...

Yeah, really nothing new (same reply as the MSFT emloyee gave in the forums thread), and actually I would have expected something more in-depth why they did such a bad job in this area.

I hesitated to wait for Linq to be released instead of buying an O/R mapper. Thanks god I did not.

Why doesn't Microsoft just bite the bullet and buy LLBLGen Pro? I'm sure Frans, like everyone, has his price.

On the one hand, it would suck because it would become "Microsoftized". On the other it would be great because it would become the standard.

there are companies out there which only get founded for this... but I think SD does not belong to them ...

Heh no we weren't founded to be bought by MS, but indeed if they pay a price we like, who knows... But I don't think they'll ever do that, they have enough people there working on the data-access stuff, one more doesn't help that much. What they lack is vision with the right people. Microsoft is a very hierarchical company, where a large group of managers decide what's included / done and the developers more or less have to follow. Needless to say, I don't want to work in such an environment .

And I for one, am eternally grateful.