RADar-AZDelta/archived-Rabbit-in-a-Blender
1
0
Fork 0
mirror of https://github.com/RADar-AZDelta/Rabbit-in-a-Blender.git synced 2026-03-23 20:37:03 +00:00
Code Issues 6 Projects Packages Wiki Activity

[GH-ISSUE #55] Speed up import of vocabularies on SQL Server #32

New issue
Closed
opened 2026-03-23 20:28:38 +00:00 by mirror · 1 comment
mirror commented 2026-03-23 20:28:38 +00:00
Owner
Copy link

Originally created by @pjlammertyn on GitHub (Apr 25, 2024).
Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/55

Originally assigned to: @pjlammertyn on GitHub.

The OHDSI DDL creates a clustered index on the _id columns.

image

The generated vocabularies CSV's bij Athena are NOT sorted on the _id column:

image

Originally created by @pjlammertyn on GitHub (Apr 25, 2024). Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/55 Originally assigned to: @pjlammertyn on GitHub. The OHDSI DDL creates a [clustered index on the _id columns](https://github.com/OHDSI/CommonDataModel/blob/main/ddl/5.4/sql_server/OMOPCDM_sql_server_5.4_indices.sql#L72). ![image](https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/assets/1187178/259e1041-9a3b-4c57-87bc-9c69dec4eff3) The generated vocabularies CSV's bij [Athena](https://athena.ohdsi.org/) are NOT sorted on the _id column: ![image](https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/assets/1187178/efe276a2-c5b3-43ef-9268-509b4e98baca)
mirror 2026-03-23 20:28:38 +00:00
mirror commented 2026-03-23 20:28:38 +00:00
Author
Owner
Copy link

@pjlammertyn commented on GitHub (Apr 25, 2024):

solved in merge request https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/pull/56

<!-- gh-comment-id:2076731180 --> @pjlammertyn commented on GitHub (Apr 25, 2024): solved in merge request https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/pull/56
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
109-episode_event-table-not-filled
issue95-make-link-between-episode_parent_id-and-episode_id
dependabot/pip/requests-2.32.0
gh-pages
0.0.74
0.0.73
0.0.72
0.0.71
0.0.70
0.0.69
0.0.68
0.0.67
0.0.66
0.0.65
0.0.64
0.0.63
0.0.62
0.0.61
0.0.60
0.0.59
0.0.58
0.0.57
0.0.56
0.0.54
0.0.53
0.0.52
0.0.51
0.0.50
0.0.48
0.0.47
0.0.45
0.0.44
0.0.42
0.0.40
0.0.39
0.0.38
0.0.37
0.0.36
0.0.35
0.0.34
Labels
Clear labels   
bug

   
cannot reproduce

   
duplicate

   
enhancement

   
experiment

   
invalid

   
pull-request

Mirrored from GitHub Pull Request

  
question

   
wontfix
No labels
bug
cannot reproduce
duplicate
enhancement
experiment
invalid
pull-request
question
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
RADar-AZDelta/archived-Rabbit-in-a-Blender#32
No description provided.