RDBMS benchmark: SQL script needed

[r3ddr]

I am planning to do a benchmark on following RDBMS: MySQL vs PostgreSQL vs Informix vs Oracle.

Could someone provide a good SQL script to test those RDBMS in real-life-like conditions?

PS. Meanwhile I will be busy setting up the environment 😉

Thanks,

ALX

[[deleted]]

You cannot do a fair comparison between mysql postgres and 'informix or oracle'.

First of all, MySQL will nearly always come out faster because it it was stripped of all the usefull functions that slow down the other databases.

In MySQL you will have to compensate for the lack of functionality by programming that functionality into your script, but your query will be very fast.

Informix and Oracle were designed to do things that MySQL can only dream of, and which even postgres is only starting to be able to do.

basically, you are trying to compare a motorcycle (mysql, simple but fast) to a car (postgresql, not as fast as mysql but much more functionality) and two high-octane fuel propelled lorries (informix and oracle, can do anything at a reasonably high speed).

[Anon]

Hi!

I have done some simple benchmarks on MySQL/InnoDB. You can look at them at http://www.innodb.com/bench.html

InnoDB is even faster in many simple benchmarks than the MyISAM table type in MySQL.

InnoDB is a MySQL table type which supports transactions, row level locking, multiversioning, and foreign key constraints.

About real-world benchmarks, I am afraid there are no SQL scripts available, because real-world applications are so complex. About real-world use see http://www.innodb.com/userstories.html

SelectBourse migrated a high-end application from MS SQL Server to MySQL/InnoDB and got better performance.

You can download MySQL-Max from http://www.mysql.com. Look at http://www.innodb.com/ibman.html about installation.

If you measure MySQL against Oracle etc. I would be interested to hear the results. I have done my own measurements, but the Oracle license prohibits publication of benchmarks.

Best regards,

Heikki Tuuri
Innobase Oy
[e-mail]

P.S. I noticed you work in Finland. I am in Helsinki too 🙂

[[deleted]]

Your benchmarks are cute, but performance is more than just speed.

It would be nice to have a bit (or a lot) more information about how you ran the benchmarks. I tend to doubt benchmarks done by someone who is closely involved with a product, because you're obviously never going to publish results that show that MySQL is slower (I wouldn't if I worked for MySQL 🙂 )

BTW: clever, mentioning you did a benchmark against Oracle but you can publish the results due to the license, and then giving a set of results without mentioning the database due to the license... 🙂