Document how to tune performance for installations with large databases

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