Update dev_scripts.sql - Githubissues

Police-Data-Accessibility-Project / prod-to-dev-migration

Regularly migrates production database and schema to development database

1 stars 0 forks source link

Update dev_scripts.sql #10

Closed maxachis closed 2 months ago

maxachis commented 2 months ago

Fixes

Partially addresses https://github.com/Police-Data-Accessibility-Project/data-sources-app/issues/345

Description

Creates materialized view for all locations to perform lookup on.

Testing

Commit to sandbox development environment, and then query typeahead_suggestions to confirm its presence.

Performance

Querying the entire table took under two seconds. A few optimizations should be able to speed this up considerably, but we're not there yet.

Docs

Not applicable.