Mar 31 2010 10:46am from Peter Pulse @uncnsrd
I see it from a different point of view.. if I am going to pay a
kazillion dollars for a database and people to run it, it damn well
better have referential integrity. That is one of the MAJOR selling
points of these systems isn't it???
Ok, well yes and no. It's a major selling point of RDBMS in general I agree with that. I don't agree that it's a major selling point of Oracle in specific, because it's become a very commoditized feature let's face it. Most of the major open source RDBMSs implement it... the value proposition of Oracle is further up the pyramid, with things like partitioning, and RAC, and replication, and all those fancypants SQL extensions, like analytical queries (some of which are standard ANSI SQL now, btw.)
In any case, foreign keys sometimes just don't work, because they can impose unpredictible lock orderings on your queries. Every time you issue DML on a constrained table, Oracle (and probably every other RDBMS suffers the same problem) spawns a child cursor/query against the parent/child tables to check indexes and enforce constraints. That child query creates the lock-order problem and as near as I've ever been able to tell, the ordering is simply undefined and can't be relied on.
So most likely FK constraints will work just fine for you for months or years, but eventually as your load creeps up and your schema becomes more complex and you have more and more disparate queries hitting it, you will start running into ORA-00060 (deadlock.) And most likely the problem is universal across RDBMS.
When this does happen, you can spend a lot of time scratching your head, analyzing Oracle dumps, and trying to fix your queries to consistify the locking order. But you will likely fail - so you either have to code around the ORA-00060 with retries, or just drop your constraints. Best not to go down the analysis route - it's so unlikely to work - just retry queries or drop constraints.
This is one reason you should never write code that DEPENDS on the presence on FK constraints in some what, particularly code that relies on CASCADE DELETE. Code must continue to function properly if the constraints have to be dropped, some day.
known to be a good way to brick your wii so I'm not too crazy about
them, plus I like the standard interface.
I can't find a specific example of the middle finger giving, but I know
for a fact it's been done.
As for netflix on wii, it seems to run really well for me too, even on
the sub par connection I deal with. It's nice where youtube and
silverlight netflix netflix wii succeeds, though I'm almost positive
that's because the wii is using higher compression that the pc doesn't
use in order to keep "quality up". I'm assuming they make a somewhat
fair assumption that you'll notice graphical artifacts alot better on a
high resolution display then you will on a standard definition tv, even
if the source content itself is standard definition.
nah, NT4 made it worse. Back in NT 3/3.51 days, the GUI layer was in userland. They went and put the whole stack from driver through GDI in the kernel for NT4 if I'm not mistaken. This persisted until XP. Vista finally took it back out when they figured out how to do it with something approaching the performance they were looking for.
Even a quick TTS will read faster then I will when I want to do something else. I really just have issues focusing on things I consider completely pointless though... ah well.
I like my Kindle. It does exactly what it's designed to do pretty
well. I wouldn't push it beyond that, though.
Right, except for that little "experimental" menu which has.... you guessed it, a browser.
I would have thought, with all the iPad hype, that it more likely could be used as a hoverboard.
I asked that, too.
These days, most of these guys are using digital tape, no less... which just seems bizarre to me.
The broadcasting industry is only just now starting to dip their collective toe into the digital age. This industry is so freakishly far behind the technology curve, it's amazing they can get anything done at all. But then, I suppose this is the industry that hasn't realized that they are soon to be obscoleted by the internet.
dell also has touch-points;
you should have a look at whether you need a via c7 or some intel thing...
Want a $139 tablet, running Android?
At that price it's almost worth getting one just to play around.
But will it work properly after the conversion?
leaves a faint ghosty outline, not unlike burn-in on traditional screens.
So, to avoid that, the Kindle flashes the entire screen, effectively
erasing any ghosting.
The alternative, of course, is to simply buy new hardware every year.
I've got this kickass core2 quad that I paid too much money for, and I have never been able to use all of it.
But now I'm using DeVeDe to create three DVDs and I'm ripping a dvd, and I've got the whole machine pinned.
And I'm watching the core temperature rise....
Finally getting my money's worth though.
Really makes me wonder what DeVeDe is doing so much, it could probably be more efficient.