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

From our Oracle test instance at

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!

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