I figured many here would be interested to read a bit from the WEKA
opensource datamining project's doc. Apologies if they sourced the
info from here originally :-)

Regards,
Andrew Ferguson

-----

21. Compliance and Performance Information

Compliance Tests:
The compliance was check with jDataMaster, which include more than
1000 tests, excluding:

CallableStatements

Escape Syntax

FB type 4 driver pass all the tests excluding

ResultSetMetaData.isReadOnly(i)

ResultSetMetaData.isWritable(i)

ResultSetMetaData.isDefinitivelyWritable(i)

The set/get tests don't include Blobs.

Firebird driver is the most JDBC compliant driver of those tested
with this tool, the next one fails on 90 tests, including all of the
most known RDBMS.





Performance tests compared with Interclient
The results of the jDataMaster basic performance tests, are the
following

Local test

Duron 800MHz with 512MB and FB 1.0 without forced Writes


Interclient
Firebird Type 4
FB as % of Interclient

Insert 5000 records with autocommit
8510 ms
14307 ms
168 %

Read 5000 records with autocommit (x5)
3052 ms
3056 ms
100 %

Insert 5000 records with one transaction
6650 ms
5552 ms
83 %

Read 5000 records inside one transaction(x5)
3990 ms
3819 ms
95 %


Remote test

Client: Windows 2000 on Duron 800MHz with 512MB.
Server: Suse 7.2 on AMD 500MHz with 256MB and FB 1.0.


Interclient
Firebird Type 4
FB as % of Interclient

Insert 5000 records with autocommit
16588 ms
17525 ms
106 %

Read 5000x5 records with autocommit
8082 ms
6247 ms
77 %

Insert 5000 records with one transaction
13009 ms
6311 ms
49 %

Read 5000x5 records inside one transaction
11639 ms
8670 ms
75 %


The time in each test is the average of 5 executions.





June-24-2002