Prunes older entries in table search_autocomplete (will speed up the autocompletion...

[platal.git] / bin / cron / clean.php

diff --git a/bin/cron/clean.php b/bin/cron/clean.php
index 3c0590d..9744d97 100755 (executable)
--- a/bin/cron/clean.php
+++ b/bin/cron/clean.php
@@ -43,6 +43,8 @@ query("ALTER TABLE groupesx_def ORDER BY text");
 query("ALTER TABLE secteur ORDER BY text");
 query("ALTER TABLE sections ORDER BY text");
 
+// Prunes older autocomplete queries.
+query("DELETE FROM search_autocomplete WHERE generated < DATE_SUB(NOW(), INTERVAL 1 DAY)");
 
 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 ?>