db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zhang Jinsheng (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-110) performance
Date Fri, 24 Dec 2004 09:56:03 GMT

         Key: DERBY-110
         URL: http://nagoya.apache.org/jira/browse/DERBY-110
     Project: Derby
        Type: Test
 Environment: CPU 2.40GHz
windows 2000

    Reporter: Zhang Jinsheng
    Priority: Minor

1. create db name systable in derby and hsqldb (another open source dbms);
2. create table named a table ('CREATE TABLE aTable(id INTEGER NOT NULL, name VARCHAR(255)
NOT NULL, description VARCHAR(255))');
3. insert ten thousands row in table "atable"
    for(int i=1; i<10000; i++) {
	sql = "INSERT INTO aTable VALUES("+i+", 'haha', 'zhang'' test')";
4. derby spend 50390 millisecond;
   hsqldb spend 4250 millisecond;
5. conclusion: hsqldb has more perfect performance.
   Maybe derby need to improve it's performance.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
If you want more information on JIRA, or have a bug to report see:

View raw message