Comments on C for Coding: Oracle vs MySQL vs SQL Server: Aggregation vs Join...

hi, I tried to run a simple test to see how the sp...

2010-09-30T10:00:31.046+08:00

hi, I tried to run a simple test to see how the speed fair between oracle and Ms Sql as follow:
populate two tables with 2 million records, cross join them, filter by a range, and do a sum. Both table structure as fellow:

create table t (
record number,
name , varchar(50),
num number //--random
)

SQL as :
select sum(a.record) from test a cross join test b where a.num between 50001 and 80000 and b.num between 80001 and 110000

Somehow the same query running on oracle perform badly when compare to Ms sql. On oracle, the timing around 20s, but on Ms Sql,the result return within 1s. As I increase the range, the timing on oracle degraded while sql still fair well.

Shall the statement on oracle be written differently? I tried searching for info but cant seem to find any information regarding this.
Wonder if you may provide some insight?

Thanks

I prefer Oracle

2010-06-23T21:57:58.738+08:00

I prefer Oracle

2010-04-09T06:28:30.852+08:00

I prefer Oracle

Competition between the industrial database backen...

2010-03-23T04:58:03.218+08:00

Competition between the industrial database backends too strong. Each of them supports the standard SQL in a certain volume, and its own dialect of SQL, allows you to squeeze the maximum out of this database. They say that Oracle - the fastest database in the world, but why then she would not compete with MySQL, which, judging by the tests, faster MS SQL Server. And everything was in order with the tests? New version of MS SQL Server - codenamed Yukon - promises to make a revolution. Which answer prepares Oracle?

I like this comment: "In those cases the ORM ...

2010-03-01T23:03:18.168+08:00

I like this comment: "In those cases the ORM will outperform the developer's clumsily handcoded sql nearly every time..." is very interesting!!!

Hello, I found this article to be very helpful an...

2009-09-28T17:02:46.457+08:00

Hello,

I found this article to be very helpful and consistent with the information I have found throughout the web. I would also like to recommend you one article

http://programminglanguagefaqs.blogspot.com/2009/09/xml-vs-mysql.html

Great post! Just one thing, I understand your sen...

2009-08-05T02:17:44.302+08:00

Great post!

Just one thing, I understand your sentiment, but I have to respectfully disagree with your last statement, "If it’s this hard for a human to write, what chance does an ORM have?"

I think the ORM has a BETTER chance in the vast majority of case where developers find SQL to be, as you say, "somehwat mystical"

In those cases the ORM will outperform the developer's clumsily handcoded sql nearly every time.

Additionially, while performance is important, I'll take developers that think of interesting applications but write slow sql code over those that write performant code but made useless applications any day.

Once again, very interesting article keep it up!