database performance: Java Linux Databases: Insert
Non-threaded Insert Performance
Overall
MySQL (MyISAM) is the clear winner here:
MySQL is an order of magnitude faster here, followed by Informix.
All the other database systems are 4 to 5 times slower than MySQL in this test, with Firebird leading the pack.
As shown in the previous chapter, MySQL is faster on i686 than on x86_64.
Initial Data Size
The amount of data in the table at the start of the test does have a negative impact on some systems:
DB2 and Postgresql suffer a large penalty with 10000 rows or more:
(Postgresql x86_64 only - see previous chapter for details on this combination)
MySQL (MyISAM) is the clear winner here:
Prepared Statements
Prepared Statements are less beneficial on insert performance than for other operations.
The odd result here is that Informix and Postgresql perform better with indexed columns than without
(when one would think it should require more work):
