Tony Andrews
On Wednesday, 9 March 2016 at 22:07:58 UTC+11, Tony Andrews wrote:
in the “The Null Problem is a Non-issue” thread
I'm afraid a "conversation" with Derek S can rarely be anything else, unless you agree to be heavily patronised. Derek hates Oracle with a passion only matched by his ignorance of it. I once spent an inordinate amount of time trying to get him to
explain to me why Oracle is a "row processor", a term he seems to have made up. After dozens of emails in which I had to do all the heavy work he eventually declared that he had now learned that it no longer was a "row processor", but had once been one (
presumably in or before the early 1980s). Of course he refused ever to explain what he meant by "row processor" because (I inferred) he deemed me too stupid to be able to understand if he did.
I don't understand why you post confirmation of your stupidity.
It was you that explained to me that some groupies use Oracle Index Organised Tables, in which records are physically grouped by the virtue of the Composite Index, and thus the "platform" has to (must needs be) perform row processing. Are you now saying
that what you, as the infamous Oracle guru, advised me of, is false ?
Second, due to the pitiful implementation, yes, many Oracle types write procedural code [row-by-row processing] instead of set processing, so in that sense, not the "platform" sense, they process rows. That is, far more than MSSQL or SYBASE or DB2
implementations write procedural code on their [actual] SQL [actual] platform.
Third, no one said that Oracle is *always* a row processor. To set that up and then attack that, is pure Straw Man. Typical of disgusting liars, as per the evidence you provide of yourself.
I had to do all the heavy work
What "heavy work" ???
Did you have to read the manuals before answering the question ? Was not the answer resident in that marvellous, cavernous, cranium of yours ?
And with this level of attack, you expect anything more than condescension and patronising. You can't be attacking me, and begging to be treated as a small child at the same time.
The only heavy work related to our conversations, that I recall, was the benchmark that you attempted. First, off someone else's question on StackOverflow, and then your own:
__
https://stackoverflow.com/questions/4083464/design-database-relating-to-time-attribute
__
https://stackoverflow.com/questions/4375192/performance-of-different-approaches-to-time-based-data
I have no doubt that (a) coding anything in Oracle, and (b) getting Oracle to perform at all in a benchmark situation, is heavy work, that noticeably I did not have to do on the Sybase side. I don't understand why you are complaining about it, and thus
advertising the non-performance of the Oracle "platform".
I did a fair amount of downgrading the table definition, and the code, at your request, due to Oracle limitations, in order to obtain a benchmark of tables+code that was reasonably comparable (no complaint, it is simple enough for me to do on the Sybase
side). But again, I appreciate that that was (c) heavy work on your side.
The benchmark results seem to have been removed from SO, here it is:
__
https://www.softwaregems.com.au/Documents/Student_Resolutions/Tony%20Andrews/Benchmark%20101204.pdf
For those who are too afraid to click, or have difficulty with detail, the Oracle “performance” in the benchmark relative to Sybase, on the similar systems (even with the Sybase side at a major disadvantage) is:
1 Subquery COUNT 3.0 x slower than Sybase
3 InlineView COUNT 3.6 x slower than Sybase
3 InlineView COUNT Improved 4.8 x slower than Sybase
1 Subquery SUM Abandoned after 120 mins
3 InlineView SUM 26.4 x slower than Sybase
3 InlineView SUM Improved 36.4 x slower than Sybase
Derek hates Oracle
Love and hate are emotions that small children have. Even the concept that hate is the opposite of love, or that if you don’t love MyLittlePony, you therefore hate it, is just adorable. Thus for you, understandably, who loves that mountain of excreta,
the absence of that perverted love, is “hate”. Ok.
As evidenced, you hate the facts, especially the facts about Oracle, that I expose (a) as a matter of the normal course of my occupation, and (b) in response to your hilarious declarations. I am a Relational and Sybase/MSSQL/DB2 expert, I have never
suggested that I am expert in non-commercial products and freeware, but I am quite familiar with it, due to interaction at various customer sites.
I accept that you hate me. I can live with that. Most Oracle types do.
I accept that you hate your father. Which is a terrible quandary, because if not for his existence and production, you would not exist.
Derek hates Oracle with a passion only matched by his ignorance of it
Please provide an example of even one instance of that alleged “ignorance”. Try not to erect a Straw Man, I will expose the dishonesty and impotence in that, and incinerate you along with your offering.
Here, I will give you some material, so that you don't have to poke around the internet with a microscope. If anything I declare here false in any way, let me know. Please use scientific, technical terms, not Oracle marketing terms (eg. the use of the
word "server" in relation to Oracle fails as a scientific or technical term, but it is a much-bandied; much-loved; blind-ignorance, term in the Oracle love community).
__
https://www.softwaregems.com.au/Documents/Article/Oracle%20Circus/Oracle%20vs%20Sybase.pdf
Cheers
Derek
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)