From 9ff39e3ee77231d67d08cb890a609181a1642ca3 Mon Sep 17 00:00:00 2001 From: hickert Date: Tue, 27 Nov 2007 10:47:34 +0000 Subject: [PATCH] Added table index, to speed up sql queries. A query over ~500000 entries, will now take less than a second. git-svn-id: https://oss.gonicus.de/repositories/gosa/trunk@7906 594d385d-05f5-0310-b6e9-bd551577e9d8 --- contrib/mysql/logging/logging.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/contrib/mysql/logging/logging.sql b/contrib/mysql/logging/logging.sql index d589e2306..856758e9f 100644 --- a/contrib/mysql/logging/logging.sql +++ b/contrib/mysql/logging/logging.sql @@ -11,4 +11,7 @@ CREATE TABLE `gosa_log` ( `changes` blob NOT NULL, `result` varchar(255) NOT NULL, PRIMARY KEY (`id`) + KEY `action` (`action`), + KEY `timestamp` (`timestamp`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; + -- 2.30.2