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

Amélioration de la vue gn_synthese.v_synthese_for_export (champ "communes") #1434

Closed
jpm-cbna opened this issue Aug 3, 2021 · 1 comment
Closed

Amélioration de la vue gn_synthese.v_synthese_for_export (champ "communes") #1434

jpm-cbna opened this issue Aug 3, 2021 · 1 comment
Assignees
@jpm-cbna @VincentCauchois
Labels
database enhancement solved in next release SQL
Milestone
2.12

Comments

@jpm-cbna
Copy link
Contributor

jpm-cbna commented Aug 3, 2021

La génération du champs "communes" dans la vue "gn_synthese.v_synthese_for_export" est assez limitant actuellement.
Les fichiers ci-dessous fournissent le SQL, le temps d'exécution ainsi que la sortie de EXPLAIN d'une requête simplifiée correspondant à cette vue dans une base de 9 millions de données :

La solution a base de LEFT JOIN LATERAL semble être la plus pertinente à mettre en place.
@jpm-cbna jpm-cbna self-assigned this Aug 3, 2021
jpm-cbna added a commit that referenced this issue Aug 3, 2021
@jpm-cbna
Feat data: improve field communes in gn_synthese.v_synthese_for_export
5709751 
Use LEFT JOIN LATERAL.

Close #1434.
@jpm-cbna jpm-cbna mentioned this issue Aug 3, 2021
Closed
@camillemonchicourt camillemonchicourt mentioned this issue Jan 27, 2023
Closed
@VincentCauchois VincentCauchois self-assigned this Feb 21, 2023
VincentCauchois pushed a commit that referenced this issue Feb 22, 2023
@jpm-cbna @VincentCauchois
Feat data: improve field communes in gn_synthese.v_synthese_for_export
0fa2970 
Use LEFT JOIN LATERAL.

Close #1434.
VincentCauchois added a commit that referenced this issue Feb 22, 2023
@VincentCauchois
Improves the view gn_synthese.v_synthese_for_export :
4289019 
execution time, and other.

Modifs in an Alembic migrations versions file,
rather than in 'synthese.sql'
and 'data/migrations/' folder

Fixes #2303
Fixes #1434
Closes #1435
@VincentCauchois VincentCauchois mentioned this issue Feb 22, 2023
Merged
VincentCauchois added a commit that referenced this issue Feb 22, 2023
@VincentCauchois
Improves the view gn_synthese.v_synthese_for_export :
ed93da6 
execution time, and other.

Modifs in an Alembic migrations versions file,
rather than in 'synthese.sql'
and 'data/migrations/' folder

Fixes #2303
Fixes #1434
Closes #1435
bouttier pushed a commit that referenced this issue Feb 22, 2023
@jpm-cbna @bouttier
Feat data: improve field communes in gn_synthese.v_synthese_for_export
56b19cf 
Use LEFT JOIN LATERAL.

Close #1434.
bouttier pushed a commit that referenced this issue Feb 22, 2023
@VincentCauchois @bouttier
Improves the view gn_synthese.v_synthese_for_export :
e0cfada 
execution time, and other.

Modifs in an Alembic migrations versions file,
rather than in 'synthese.sql'
and 'data/migrations/' folder

Fixes #2303
Fixes #1434
Closes #1435
bouttier pushed a commit that referenced this issue Feb 23, 2023
@jpm-cbna @bouttier
Feat data: improve field communes in gn_synthese.v_synthese_for_export
673e7cb 
Use LEFT JOIN LATERAL.

Close #1434.
bouttier pushed a commit that referenced this issue Feb 23, 2023
@VincentCauchois @bouttier
Improves the view gn_synthese.v_synthese_for_export :
4ee1474 
execution time, and other.

Modifs in an Alembic migrations versions file,
rather than in 'synthese.sql'
and 'data/migrations/' folder

Fixes #2303
Fixes #1434
Closes #1435
@bouttier bouttier added this to the 2.12 milestone Mar 1, 2023
@bouttier
Copy link
Contributor

bouttier commented Mar 1, 2023

Fait dans #2357 qui reprend ce qui avait été initialement fait dans #1435

@bouttier bouttier closed this as completed Mar 1, 2023
@camillemonchicourt camillemonchicourt mentioned this issue Jan 17, 2024
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jpm-cbna jpm-cbna

@VincentCauchois VincentCauchois

Labels
database enhancement solved in next release SQL
Projects
None yet
Milestone
2.12
Development

No branches or pull requests
3 participants
@bouttier @jpm-cbna @VincentCauchois