[ 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