cfpb / django-hud / 14

76%

master: 76%

push

travis-ci

add additional index to CachedGeoData

@marcesher made the observation that queries against cached geodata
could potentially be optimized through use of an additional index. When
the cached geodata is queried in `hud_api_replace.geocode`, it's looked
up using Python code like

```py
CachedGeodata.objects.filter(expires__gte=time.time()).get(key=address)
```

In practice this results in SQL like

```sql
SELECT * FROM hud_api_replace_cachedgeodata
WHERE expires >= %s AND key = %s
```

This commit adds a joint index on these two columns, which should speed
up these queries. See Django documentation on `index_together` at

https://docs.djangoproject.com/en/1.8/ref/models/options/#index-together

7 of 7 new or added lines in 2 files covered. (100.0%)

572 of 757 relevant lines covered (75.56%)

3.0 hits per line