Databases are fast at INSERTs! 1¼ minutes to insert 1¼ million rows (on a test server!)

From our Oracle test instance at uboot.com:

1360965 rows created.
Elapsed: 00:01:17.90

That's 1¼ minutes to insert (and index) over 1¼ million rows.

And this is a very old test instance. I think the hardware was last updated 2-3 years ago.

That's pretty quick!

P.S. I recently created a nerdy privacy-respecting tool called When Will I Run Out Of Money? It's available for free if you want to check it out.

This article is © Adrian Smith.
It was originally published on 28 Mar 2007
More on: Oracle | uboot.com | Operations & Servers | Databases