search

labsquare / cutevariant

A standalone and free application to explore genetics variations from VCF file
https://cutevariant.labsquare.org/
GNU General Public License v3.0
102 stars 21 forks source link

[SQL] Classification of a sample take a while #541

Closed antonylebechec closed 2 years ago

antonylebechec commented 2 years ago

Please edit this template:

Describe the bug Classification of a sample take a while with a project with a lot of samples

To Reproduce Steps to reproduce the behavior, for example:

  1. Create/Select a project with a lot of samples
  2. Classify a sample with a "positive" classification
  3. Wait...

Note: Probably the "count_validation_positive_negative_after_update_on_samples" trigger for calculation:

Expected behavior Fluent classification.

Desktop (please complete the following information):

Additional context Suggestion: Remove "count_validation_positive_negative_after_update_on_samples" trigger

antonylebechec commented 2 years ago

Due to a trigger on a variants field