[ http://issues.apache.org/jira/browse/DERBY-465?page=comments#action_12316262 ]
Mike Matrigali commented on DERBY-465: -------------------------------------- note that the results of the select * tests posted at http://jamie.ideasasylum.com/notebook/index.php?id=4, show 50,000 row select of same table you are using takes 375 ms. on a slightly slower machine. There is definitely something strange going on with your results. I have read over the .java files you posted and nothing jumps out at me. I recommend debugging the single user derby select test, verify number of rows and that you aren't missing any errors. > 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, 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
