1006779 - [tarako] optimize icons on production

Status: RESOLVED FIXED

(Marketplace Graveyard :: General, defect, P1)

Description

[David Durst [:ddurst]]

We should optimize icons on production.

So they're smaller. And they download faster.

Comment 1

[Mathieu Pillard [:mat]]

We ran the command in prod with jason, it was super-fast. It appears to have worked *except* that I forgot to update the icon hash in the command, which means we need to do this manually.

The SQL to run is:
UPDATE `addons` 
SET `icon_hash` = 'crushed'
WHERE (`addons`.`addontype_id` = 11  AND `addons`.`status` IN (4, 13, 2) AND `addons`.`icon_hash` IS NULL);

And then we need to reindex:
./manage.py reindex_mkt --settings=settings_local_mkt

Comment 2

[Mathieu Pillard [:mat]]

We ran everything. I'm hitting bug 995288 sometimes which prevents me from seeing the benefits on apps I already visited, but otherwise we're good now.