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

By Adrian Smith28 Mar 2007100 words1 mins to read

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 was written by Adrian Smith on 28 Mar 2007

Follow me: Facebook | Twitter | LinkedIn | Email

More on: Oracle | | Operations & Servers | Databases