Forums

Old page versions [job]

Permalink
Hi guys,

at the moment I've like 14000 records in the table 'CollectionVersions' thus I wanted to remove some unnecessary records. The dashboard job to remove old page versions, however, does seem to take quite a while!

It removes about 1 record in 30 seconds... Is there any way to optimize this?

For example, can I manually run some queries, or is that bad practice?
 
peterrr replied on at Permalink Reply
A guy from IRC advised me to put this line in site.php:

define('CACHE_FRONTEND_OPTIONS', serialize(array('automatic_cleaning_factor' => 0)));


It increased general performance and made the job run faster as well!