Fix issue #69 : ajout d'une option pour optimiser la BDD + correction bug script actualisation lorsque connexion paramétrée

1 files changed, 6 insertions, 0 deletions

diff --git a/app/models/Entry.php b/app/models/Entry.php
index 050407390..6af3178ee 100755
--- a/app/models/Entry.php
+++ b/app/models/Entry.php
@@ -509,6 +509,12 @@ class EntryDAO extends Model_pdo {
 
 		return $res[0]['count'];
 	}
+
+	public function optimizeTable() {
+		$sql = 'OPTIMIZE TABLE entry';
+		$stm = $this->bd->prepare ($sql);
+		$stm->execute ();
+	}
 }
 
 class HelperEntry {