Requests including charm-related are very slow

[hatched]

The request in question: https://api.jujucharms.com/charmstore/v4/trusty/mariadb/meta/any?include=bundle-metadata&include=charm-metadata&include=charm-config&include=manifest&include=stats&include=charm-related&include=extra-info&include=tags

Takes almost 14s to respond and is ~200kb

[mhilton]

There seems to me to be much more data here than is useful. Perhaps we can cut it down and make it quicker. What do you do with the charm-related data?

[frankban]

See https://api.jujucharms.com/charmstore/v5/postgresql/meta/charm-related for instance. This also affects the charm command, see https://github.com/juju/charmstore-client/issues/68 We definitely need to reduce the number of results for charm-related.