1
76%
master: 76%

Ran 22 Aug 2017 08:35PM UTC

Files 19

Run time 2min

Badge

Embed ▾

Committed 22 Aug 2017 08:30PM UTC coverage: 74.769%. First build

Job # TOXENV=py27-dj18

Build Type

push

travis-ci

Committed by

chosak

Commit Message

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

Run Details

566 of 757 relevant lines covered (74.77%)

0.75 hits per line

cfpb / django-hud / 14 / 1
76%
master: 76%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 14.1 (TOXENV=py27-dj18)

cfpb / django-hud / 14 / 1 76% master: 76%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 14.1 (TOXENV=py27-dj18)

cfpb / django-hud / 14 / 1
76%
master: 76%

README BADGES
x