Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Optimisation of a sql query

Re: Optimisation of a sql query

From: Bob Jones <email_at_me.not>
Date: Fri, 21 Jul 2006 03:24:48 GMT
Message-ID: <4OXvg.175756$F_3.23664@newssvr29.news.prodigy.net>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US