Re: Would be really nice if...

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:1109299024.548780_at_yasure...
> Haximus wrote:
>
>
>> And if those two columns happen to be blobs containing large amounts of
>> data, you inadvertantly just initiated a huge amount of traffic and
>> resource consumption.
>
> Then you stop being lazy and earn your paycheck.

Oh lighten up will ya! Don't presume to know what I do for a paycheck and I will extend the same courtesy to you.

>
>>> In the second case I select all columns and use only two of them.
>>> Where is the pain?
>>
>> The pain is that it's a waste. C'mon, you can do better than that!
>
> There is no waste as the demo clearly shows. You, of course, didn't
> bother to run the demo.

Nope, and to tell you the truth I have no use for PL/SQL except in the role of basic data processing. In my work I deal with a lot of non-linear problem solving involving complex OO models that would be next to impossible to achieve with PL/SQL, but data management needs still require the performance of Oracle for passivation as well as basic pre-processing. PL/SQL is something I practically never use in daily life, it's a dinosaur that will eventually become extinct when all the RDBMS-centric DBA's someday see the light. Received on Thu Feb 24 2005 - 22:02:10 CST