The query DELETE FROM archive_name is triggered by the garbage collector. This query may run for several hours depends on the amount of artifacts that were deleted, removes and cleans the unnecessary indexing.
The UPDATE unique_ids query is used to reserve unique id’s (that are being used by Artifactory to identify items with unique id’s). In order to decrease the amount of inquiries to the database you can change the size of reserved id’s by making changes in the $ARTIFACTORY_HOME/etc/artifactory.system.properties file. The value that need to be modified is
artifactory.db.idGenerator.fetch.amount={size_of_reserved_ids}. Please uncomment this line. The default value is between 2000. Please increase this value to as needed (e.g. around 10000). Please note that this change requires restart of Artifactory server. The increasing the size of the reserved id’s would allow Artifactory to work fluently with less wait time (locks) for reserving the id’s.
The UPDATE unique_ids query is used to reserve unique id’s (that are being used by Artifactory to identify items with unique id’s). In order to decrease the amount of inquiries to the database you can change the size of reserved id’s by making changes in the $ARTIFACTORY_HOME/etc/artifactory.system.properties file. The value that need to be modified is
artifactory.db.idGenerator.fetch.amount={size_of_reserved_ids}. Please uncomment this line. The default value is between 2000. Please increase this value to as needed (e.g. around 10000). Please note that this change requires restart of Artifactory server. The increasing the size of the reserved id’s would allow Artifactory to work fluently with less wait time (locks) for reserving the id’s.