Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Optimisation du check vérifiant le référentiel taxonomique #424

Closed
bouttier opened this issue Jan 23, 2023 · 1 comment
Closed

Optimisation du check vérifiant le référentiel taxonomique #424

bouttier opened this issue Jan 23, 2023 · 1 comment
Assignees
@Pierre-Narcisi
Labels
enhancement New feature or request solved in next release This issue will be fixed in next release

Comments

@bouttier
Copy link
Contributor

Les données source sont dans la colonne texte src_cd_nom et on fait une jointure src_cd_nom = CAST(taxonomie.taxref.cd_nom AS VARCHAR) ce qui est assez long. CAST(src_cd_nom AS INTEGER) = taxonomie.taxref.cd_nom serait probablement plus efficace. Il faut tous de même s’assurer que les checks de type exclue bien les lignes dont src_cd_nom ne sont pas des entiers, sans quoi la transaction va échouer.
@bouttier bouttier added the enhancement New feature or request label Jan 23, 2023
@camillemonchicourt camillemonchicourt mentioned this issue Aug 31, 2023
Closed
@camillemonchicourt camillemonchicourt added the solved in next release This issue will be fixed in next release label Sep 28, 2023
@camillemonchicourt
Copy link
Member

Fait dans #482, intégré dans la version 2.2.3.
Avec d'importants gains de performances, détaillés dans #468

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Pierre-Narcisi Pierre-Narcisi

Labels
enhancement New feature or request solved in next release This issue will be fixed in next release
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@bouttier @camillemonchicourt @Pierre-Narcisi