Skip to content

Speed up SimPathsModel.getProcessed #256

@andrewbaxter439

Description

@andrewbaxter439

Some things to try out

  • Lazy lookups when multiple joins are needed - joining household->benefitUnit->members seems to be very slow for example. Perhaps need to adjust this
  • Indexes may help lookup in some cases of SQL? Particularly in populateDonorTaxUnitTables where lookup by systemYear=" + systemYear; is very slow
  • Parse column types as decimals on reading in, rather than altering afterwards?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions