#56354Speed up updating the extension list
Description
The process of updating the TER
extension list takes approx 1 minute
because the extension manager needs
to mark all “latest versions”. This is done
via a large UPDATE query on fields
without indices, additionally this is done
in PHP and not in SQL with a
simple subselect.
Additionally the SQL file does not set
appropriate indices at all, which is also
done in this patch.