offlist Re: Cocoa/EOF for non-enterprise apps Re: proof of cocoa superiority?
offlist Re: Cocoa/EOF for non-enterprise apps Re: proof of cocoa superiority?
- Subject: offlist Re: Cocoa/EOF for non-enterprise apps Re: proof of cocoa superiority?
- From: Deirdre Saoirse Moen <email@hidden>
- Date: Wed, 13 Jun 2001 11:40:48 -0700
This is really off the topic of cocoa, so I decided to respond privately.
We must have different ideas as to what constitutes a "long time" to write
=). The time it takes simply to type 19 pages would fall into a "long
time" in my mind, but I'm the impatient sort. Not that I haven't spent
large amounts of time on many projects, but...
Well, that was the outside in both time and length and probably
complexity. Most of the stuff I do is more like two temporary views
joined to at most five tables.
In my experience, however, it's not primarily the length of the SQL that
makes it take a long time to write. I have a chunk of SQL that's about 3
pages long that hits 11 tables, but it has a huge number of nested
subselects, many that are introspective. The biggest problem is that some
of the tables are massively denormalized, which makes the associations
necessary to avoid cartesian return complex and numerous.
True -- sometimes denormalization is the only way to cope. Alas.
>Let's just say I'd be very surprised if EOF could do it.
EOF? I'm surprised the database optimizer could handle it without giving
you mostly row scans and lazy spools. Oh, wait, if you were on Oracle 6,
you were using the rule-based optimizer so YOU were the optimizer. Yuck.
Got it in 1. :)
Oracle has a particularly volatile history, but other databases have
similar histories. But I still stand by my statement, we are (IMHO) at a
fairly stable point in DB development. I doubt we'll see big changes AWAY
from standards from here on, so I don't think maintaining the adapters
would be that huge of a task.
True.
--
_Deirdre Stash-o-Matic:
http://weirdre.com http://deirdre.net
"Cannot run out of time.... Is infinite time. You... are finite....
Zathrus... is finite. This... is wrong tool!" -- Zathrus