db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Peter Kovgan (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-465) Embedded Derby-PointBase comparison
Date Tue, 26 Jul 2005 14:09:18 GMT
     [ http://issues.apache.org/jira/browse/DERBY-465?page=all ]

Peter Kovgan updated DERBY-465:
-------------------------------

    Attachment: DBBenchmarkProject.zip

While I'm testing and checking I want to allow you see source code of test program.
You need compile it and change paths in scripts(.bat files) to run, also parameters in scripts
may be wrong, but you in general can reproduce 
Several situations: multi-user access, write mode, read mode, indexing on table, auto commit=true/false
and other.
I'll send you results of tests later.


> Embedded Derby-PointBase comparison
> -----------------------------------
>
>          Key: DERBY-465
>          URL: http://issues.apache.org/jira/browse/DERBY-465
>      Project: Derby
>         Type: Wish
>   Components: Test
>     Versions: 10.0.2.1, 10.0.2.0
>  Environment: Windows Server 2003, 4 processors, summary CPU 3.00 Ghz, RAM 1 Gb
>     Reporter: Peter Kovgan
>  Attachments: Benchmarks_info_independent.doc, DBBenchmarkProject.zip, DBOperations.java,
Multithreading-access read.doc, User.java, derby-optimization.doc, derby-pb1.doc
>
> I have tested 4 major embedded DB.
> I have found that major disadvantage of Derby is 
> 1)low insert speed and 
> 2)significant performance degradation in select, update, delete  operation speed starting
from some table size.
> PointBase in comparison has not such degradation.
> It will be better if you improve your product.
> Good luck and thank you.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message