[geeks] Oracle dbs on Sun T2000?

[Charles Shannon Hendrix]

Tue, 20 Jun 2006 @ 19:01 +0100, Mike Meredith said:

> Some third party applications written for small markets seem to be
> written by programmers who should really take up basket weaving. There's
> three names that if I use in the same sentence will cause the DBAs at
> work to start cowering in the corner. One does something so unspeakable
> to Oracle (many Oracle customers have been tempted, but it isn't
> something you should do in a released application) that we can't use any
> Oracle hot backup tools on the relevant instance.

Years ago at a very large bank that currently claims allegiance to the
wrong nation (pause), I found very expensive commercial products that
were pretty terrible.  I mean, even things like erroneous cartesian
products, and massive redundant queries, huge outside joins when the
database provided enough relations to avoid them, etc.

The products were not just off-the-shelf stuff, it was even things
written by "experienced" SQL programmers from very large and expensive
contractors.  

Most of the time on that project, a cartesian product was the culprit,
or worse, a cartesian product error masked by a filter keyword like
"distinct".

-- 
shannon "AT" widomaker.com -- ["I wish life was not so short. Languages
take such a time, and so do all the things one wants to know about." - J.
R. R. Tolkien]