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

Store event downloads in separate tables #599

Open
MattBlissett opened this issue Jul 18, 2024 · 0 comments
Open

Store event downloads in separate tables #599

MattBlissett opened this issue Jul 18, 2024 · 0 comments
Assignees
@muttcg

Comments

@MattBlissett
Copy link
Member

To improve performance, event downloads should get their own tables (event_download and dataset_event_download), which will avoid a slow join when querying dataset_occurrence_download.
@muttcg muttcg self-assigned this Jul 22, 2024
muttcg added a commit that referenced this issue Jul 22, 2024
@muttcg
#599 Add 139-event-download-tables.xml
4d94334
muttcg added a commit that referenced this issue Jul 22, 2024
@muttcg
#599 Move DDL to the file event-downloads-schema.sql
68c13e8
@fmendezh fmendezh assigned ahakanzn and muttcg and unassigned muttcg and ahakanzn Aug 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@muttcg muttcg

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@MattBlissett @muttcg @ahakanzn