search

bcgov / wqbench

R package to generate download and compile data from EPA ECOTOX database
Apache License 2.0
3 stars 2 forks source link

`wqb_create_epa_ecotox()` add indexes #5

Closed aylapear closed 1 year ago

aylapear commented 1 year ago

If things are slow to join downstream look at adding indexes to the tables. SQLite allows you to add indexes after the table is created with DBI::dbExecute(con, "CREATE INDEX <index_name> ON <table_name>(<col_name>)")

aylapear commented 1 year ago

Only add indexes to the tables that we are joining in the compile steps

aylapear commented 1 year ago

Things are not very slow at this point

aylapear commented 1 year ago

Database building is not very slow, not required at this time for minimal interaction with database object