Ok this is intresting topic. We started a discussion about databases. In just my past company we have develop & deployed 35+ SQL Server based applications and few Oracle ones. A colleague of mine gave me a run though IBM DB2. It sounds like very promising database. I just want to run a script on different databases and see how good their execution times are. Probably compare them as well.
Concept of test:
Create a table with 1 10 character column with 10 records initially. Now do a SELECT INTO self 20 times to get 1 Million records. Record the times in various databases.
The code would be as follows, we have to mak udpates to script for each databases.
--Creates Table and inserts 10 records
CREATE TABLE [SizeTest] (
[Col] [nvarchar] (10) COLLATE Latin1_General_CI_AS NOT NULL
--Add 10 records
INSERT INTO SizeTest(Col)
--5 Times for each TRANS
--2 times = 10k records
--Each record has 10 characters
DECLARE @I INT
DECLARE @N INT
SET @I = 1
SET @N = 20