db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ivan Ooi <ivanooide...@gmail.com>
Subject Tested HSQLDB faster than Derby ? Did I miss anythings ?
Date Sun, 01 Jan 2006 07:03:24 GMT
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.EmbeddedDriver
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

Mime
View raw message