Re: Delete cascade?
Re: Delete cascade?
- Subject: Re: Delete cascade?
- From: Ray Kiddy <email@hidden>
- Date: Tue, 20 Mar 2007 11:39:00 -0700
On Mar 20, 2007, at 10:43 AM, Chuck Hill wrote:
Hi Ian,
On Mar 19, 2007, at 5:47 PM, Ian Joyner wrote:
On 20/03/2007, at 10:48 AM, Chuck Hill wrote:
On Mar 19, 2007, at 4:20 PM, Ian Joyner wrote:
On 20/03/2007, at 2:57 AM, Chuck Hill wrote:
On Mar 18, 2007, at 10:11 PM, Ian Joyner wrote:
<snip>
This discussion just makes me say. WO and EOF have certain
abstractions. The object graph is one of the strongest. We often see
non-optimal SQL as a result of this. There are things that can be
done to improve the situation, like upgrading the adaptors in less
than five years, but that is a separate issue.
The point is there will always be non-optimal SQL from EOF because
EOF is at a different layer of abstraction. It is arguably impossible
to completely allow all customizations available at a lower level of
abstraction to the higher level of abstraction. C cannot do
everything that assembly language can do in the same way, and so on.
It is as if you have a performer on a grand piano and he also wants a
drumstick and a cymbal. You can give him one. How is it going to
sound? But, hey, he just wants to hit something. He can see it, so
why can he not hit it? So there it is. Of course, it is easier to
resist workarounds if real bugs in WO get fixed.
I once talked to a guy at WWDC who had trained himself in WO. He was
a long-time SQL hacker. He wondered why his app was so slow. He had,
essentially, taken his entire model apart and was using straight SQL
for everything. There were no relationships in his model. He did SQL
joins himself and just used EOF to package up the results. It is hard
to know what to say to such people.
But having, for example, a "list.@count" turn into a "select count(*)
from table;" is a step down that same road. It is perhaps a
reasonable step, but it is on that same road.
I still do some apps completely in SQL. I like SQL. But WO is good at
what it does. If it hard to achieve fine-grained control in a certain
area, that tells me to stop doing it that way. If I back up and
figure out a different way to look at the problem, I usually get
better results and less bruising on the forehead.
FWIW - ray
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden