[icinga-checkins] icinga.org: icinga-web/master: * Added index file (fixes #1055)

git at icinga.org git at icinga.org
Wed Jan 26 17:53:21 CET 2011


Module: icinga-web
Branch: master
Commit: a174136604cdc36aa36c644cbaf3122303dec7cb
URL:    https://git.icinga.org/?p=icinga-web.git;a=commit;h=a174136604cdc36aa36c644cbaf3122303dec7cb

Author: Marius Hein <marius.hein at netways.de>
Date:   Wed Jan 26 17:41:10 2011 +0100

* Added index file (fixes #1055)
* Removed debug statements

---

 .../lib/template/IcingaTemplateWorker.class.php    |    3 +--
 etc/contrib/ido/indexes.mysql.sql                  |    3 +++
 2 files changed, 4 insertions(+), 2 deletions(-)

diff --git a/app/modules/Web/lib/template/IcingaTemplateWorker.class.php b/app/modules/Web/lib/template/IcingaTemplateWorker.class.php
index d2e2e6f..f7ae3c7 100755
--- a/app/modules/Web/lib/template/IcingaTemplateWorker.class.php
+++ b/app/modules/Web/lib/template/IcingaTemplateWorker.class.php
@@ -143,8 +143,7 @@ class IcingaTemplateWorker {
 		if ($this->api_search !== null) {
 			$data = array ();
 			$dataSet = $this->api_search->fetch();
-//			var_dump($this->api_search);
-//			die();
+			
 			foreach ($dataSet as $result) {
 				if ($this->result_count === null) {
 					$this->result_count = $result->getResultCount();
diff --git a/etc/contrib/ido/indexes.mysql.sql b/etc/contrib/ido/indexes.mysql.sql
new file mode 100644
index 0000000..1b6432c
--- /dev/null
+++ b/etc/contrib/ido/indexes.mysql.sql
@@ -0,0 +1,3 @@
+
+ALTER TABLE `icinga`.`icinga_logentries` 
+ADD INDEX `icinga_web_time` (`instance_id` ASC, `logentry_time` DESC) ;





More information about the icinga-checkins mailing list