Table 1

Computer program development, runtimes and relative efficiency

Program nameTime to complete 100 000 rowsTime to complete entire 3.1M translationsRelative efficiency
Linear programme12.5 hours16.1 days
Parallelised programme with hash table1.2 min38 min610.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.