|
|
|
|
|
|
| Author |
Message |
Joel Garry
*nix forums Guru
Joined: 24 Mar 2005
Posts: 1044
|
 Posted: Thu Jul 20, 2006 2:03 pm Post subject:
Re: Optimisation of a sql query
|
|
|
Bob Jones wrote:
| Quote: | 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?
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.
jg
--
@home.com is bogus.
The woman who mistook her hat for a horse:
http://www.signonsandiego.com/teaserimages/060720delmarhat.jpg |
|
| Back to top |
|
 |
Bob Jones
*nix forums Guru Wannabe
Joined: 28 Jun 2005
Posts: 265
|
| Posted: Fri Jul 21, 2006 3:24 am Post subject:
Re: Optimisation of a sql query
|
|
|
"joel garry" <joel-garry@home.com> wrote in message
news:1153404182.225435.310230@i3g2000cwc.googlegroups.com...
| Quote: |
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.
| Quote: | 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? |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Thu Dec 04, 2008 1:32 am | All times are GMT
|
|
Debt Consolidation | Mortgage | Credit Card Debt Consolidation | Car Finance | Online Advertising
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Server
