[jira] [Closed] (CONTINUUM-2759) Document how to tune performance for installations with large databases

["Brent N Atkinson (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CONTINUUM-2759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brent N Atkinson closed CONTINUUM-2759.
---------------------------------------
    Resolution: Fixed

Fixed in r1678034

> Document how to tune performance for installations with large databases
> -----------------------------------------------------------------------
>
>                 Key: CONTINUUM-2759
>                 URL: https://issues.apache.org/jira/browse/CONTINUUM-2759
>             Project: Continuum
>          Issue Type: Task
>            Reporter: Brent N Atkinson
>            Assignee: Brent N Atkinson
>             Fix For: 1.5.0
>
>
> For users wishing to run Continuum in scenarios where the data set will grow to a large scale, instructions on how to go about tuning the database should be documented.
> Continuum 1.5 addresses multiple performance and stability issues. The net result is that it should now be possible to run Continuum with much larger databases if properly tuned. Ideally, this tuning would be automatic. However, this is not generally possible due to supporting multiple deployment scenarios and databases.
> The following should be documented:
>   * How to configure Continuum to use derbynet data sources
>   * How to enable derby query execution plan logging
>   * How to upgrade derby databases to gain optimizer statistics
>   * Common bottlenecks and tuning advice:
>   ** Creating/rebuilding indexes for long queries/large tables
>   ** Updating statistics



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)