Issue Bug Closed

#56354Speed up updating the extension list

Benni Mack 02/26/14, 18:49 updated 10/23/17, 21:40

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.

Reviews 1