[ http://issues.apache.org/jira/browse/DERBY-465?page=comments#action_12316259 ]
Mike Matrigali commented on DERBY-465: -------------------------------------- A question on the derby-pb1.doc. It looks like the update statement used by derby and the one for pb use 2 totally different fields in the update statement. Is this a problem with the test, or maybe a typo? For the set of queries described in derby-pb1.doc, derby will need an index created on the mvalue column, to get reasonable delete/update/select performance for a large number of rows where the subset of rows determined by the where clause is a small set of rows. The original benchmark you based your work on, did not have any where clause queries so did not need any indexes. There is automatically an index on the primary key you create but none of your queries actually use the primary key. So far I am at a loss to explain your newest test results. On similar tests of selecting all rows from from a table we see results in the 100,000 rows/second range, on much slower machines than you have. Your single user result if I read the doc right is reporting 140 seconds for 10 cycles of 100,000 rows. I would expect something in the 5-10 second range. It looks like you must have a .java file with the actual queries that extends DBOperations - any chance not the same test was run against pb and derby? > 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
