Opened 13 years ago
Last modified 13 years ago
#1616 closed task
Clone reporter information to per-experiment tables in the dynamic database — at Initial Version
Reported by: | Nicklas Nordborg | Owned by: | everyone |
---|---|---|---|
Priority: | critical | Milestone: | BASE 3.1 |
Component: | core | Version: | |
Keywords: | Cc: |
Description
The idea is to increase performance issues arising from a large reporter table when joining this with analyzed data in the dynamic database. The cloned table should contain only the reporters that have been used in the experiment. It should be possible to manually synchronize the cloned table with the master table to update the annotations or to add more reporters after adding raw bioassays (that may reference reporters that wasn't referenced before).
This ticket is related to #1280 (Versioned annotations of reporters).
An advanced feature would be to clone only a selected set of reporter annotations. For simplicity reasons and to avoid user confusion an administrator should be responsible for setting up presets that regular users can choose between when setting up the experiment. It should be possible to select a different preset when synchronizing (which means that the existing table needs to be dropped and re-created with the new columns).