Program name | Time to complete 100 000 rows | Time to complete entire 3.1M translations | Relative efficiency |
Linear programme | 12.5 hours | 16.1 days | 1× |
Parallelised programme with hash table | 1.2 min | 38 min | 610.1× |
A programme was developed that successfully standardised the comorbidity coding system used in a 15.7 million patient database spanning 2003–2016. Parallelising this programme and implementing a hash table increased the speed by more than 600-fold, allowing 3.1 million patient rows to be updated in under 40 min.