Details
-
Task
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Upgrade the derby embedded driver that Continuum uses for its bundled database so that it can be tuned for improved performance. The version currently bundled does not have the ability to compute table statistics and the cost-based optimizer does not always select intelligent execution plans when there are useful indices to use.
Later versions of the derby driver should be able to run against older databases using the soft-upgrade feature. To gain enhanced capabilities it will require doing a hard-upgrade. Completion of this task would make it possible to improve Continuum's performance by tuning indexes and computing statistics on tables. It will not necessarily make the application faster immediately.