Hi all,

 I did an insert 5096 rows test on Derby and HSQLDB. i found out
HSQLDB a bit faster... Anythings else that i miss in this test ?

Here is the test :-

Derby version 10.1.2
---------
org.apache.derby.jdbc.Embedded
Driver
url=jdbc:derby:DerbyTest;create=true

Auto Commit off.

using global temporary table.
(cached table was used in HSQLDB)

Created a table with 18 columns. ( A real situation)
Column type included INTEGER, VARCHAR, TIMESTAP and NUMERIC

Derby database page size set using :-
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( 'derby.storage.pageSize','32768')

Prepared statement was used.

execute using Batch process.

Derby      result : 3395ms
HSQLDB result : 1011ms