Closed nevali closed 8 years ago
Currently the list of audience URIs can only be discovered by a SELECT DISTINCT query on the media table, which is not performant.
SELECT DISTINCT
media
Instead, store the list of audience URIs in a separate audiences table which can be queried directly.
audiences
Currently the list of audience URIs can only be discovered by a
SELECT DISTINCTquery on themediatable, which is not performant.Instead, store the list of audience URIs in a separate
audiencestable which can be queried directly.