Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Optimisation of a sql query
"joel garry" <joel-garry_at_home.com> wrote in message
news:1153404182.225435.310230_at_i3g2000cwc.googlegroups.com...
>
> Bob Jones wrote:
>> > And Mladen is wrong about one thing, portable SQL will not suck equally
>> > on every database. It will likely suck extremely badly on some
>> > databases, but only suck very badly on others.
>> >
>>
>> Non-portable SQL has no chance to suck on other databases at all.
>
> And that's a bad thing?
>
That is a very bad thing when one has to move SQL from one database platform to another.
> Bob, I work daily with portable code. I deal with unnecessary problems
> daily with portable code. In fact, it is quite lucrative, as few
> people understand both the semantics of the code (it's not SQL, but
> rather a 4GL that generates SQL for OCI) and the issues on the Oracle
> side, and how to deal the frustrations involved in not being able to
> fully utilize Oracle. It actually does perform amazingly well, if you
> ignore the lockups due to a non-Oracle locking and concurrency model,
> and having to manually fix flags in the data when things go south, and
> ignore some pretty poor programming by high priced consultants. I
> guess you could say that about any cross-db enterprise software, eh?
> At least this one gives customers all the source - which means any site
> will likely have some verrrrrrrry strange code.
>
We are only talking about SQL, are we not? Received on Thu Jul 20 2006 - 22:24:48 CDT