[pLog-svn] r2158 - plog/branches/plog-1.0.2

[oscar at devel.plogworld.net]

Author: oscar
Date: 2005-06-02 20:28:37 +0000 (Thu, 02 Jun 2005)
New Revision: 2158

Modified:
   plog/branches/plog-1.0.2/wizard.php
Log:
added two more indexes that will definitely help to improve the performance of some queries


Modified: plog/branches/plog-1.0.2/wizard.php
===================================================================
--- plog/branches/plog-1.0.2/wizard.php	2005-06-02 13:28:11 UTC (rev 2157)
+++ plog/branches/plog-1.0.2/wizard.php	2005-06-02 20:28:37 UTC (rev 2158)
@@ -88,7 +88,9 @@
   KEY user_id (user_id),
   KEY slug (slug),
   KEY blog_id_slug (blog_id,slug),
-  KEY blog_id_slug_category_id (blog_id,slug,category_id)
+  KEY blog_id_slug_category_id (blog_id,slug,category_id),
+  KEY date(date),
+  KEY status(status),
 ) TYPE=MyISAM;";
 
     $Tables[1]["desc"] = "Article categories";
@@ -444,7 +446,10 @@
                                  "ALTER TABLE {dbprefix}articles ADD KEY slug(slug)",
                                  "ALTER TABLE {dbprefix}articles ADD KEY user_id(user_id)",
                                  "ALTER TABLE {dbprefix}articles ADD KEY blog_id_slug(blog_id,slug)",
-                                 "ALTER TABLE {dbprefix}articles ADD KEY blog_id_slug_category_id(blog_id,slug,category_id)");
+                                 "ALTER TABLE {dbprefix}articles ADD KEY blog_id_slug_category_id(blog_id,slug,category_id)",
+                                 "ALTER TABLE {dbprefix}articles ADD KEY date(date)",
+                                 "ALTER TABLE {dbprefix}articles ADD KEY status(status)" );
+                                 
 
     $Changes["Article Categories"] = Array( "ALTER TABLE {dbprefix}articles_categories ADD COLUMN parent_id INTEGER(10) NOT NULL DEFAULT 0",
                                             "ALTER TABLE {dbprefix}articles_categories ADD COLUMN mangled_name VARCHAR(255) NOT NULL DEFAULT ''",
@@ -554,7 +559,7 @@
 $Inserts[21] = "INSERT INTO {dbprefix}config (config_key, config_value, value_type) VALUES ('htmlarea_enabled','1',1);";
 $Inserts[22] = "INSERT INTO {dbprefix}config (config_key, config_value, value_type) VALUES ('plugin_manager_enabled','1',1);";
 $Inserts[23] = "INSERT INTO {dbprefix}config (config_key, config_value, value_type) VALUES ('check_email_address_validity','0',1);";
-$Inserts[24] = "INSERT INTO {dbprefix}config (config_key, config_value, value_type) VALUES ('summary_page_show_max','15',1);";
+$Inserts[24] = "INSERT INTO {dbprefix}config (config_key, config_value, value_type) VALUES ('summary_page_show_max','10',1);";
 $Inserts[25] = "INSERT INTO {dbprefix}config (config_key, config_value, value_type) VALUES ('minimum_password_length','4',1);";
 $Inserts[26] = "INSERT INTO {dbprefix}config (config_key, config_value, value_type) VALUES ('templates','a:3:{i:0;s:7:\"blueish\";i:1;s:4:\"grey\";i:2;s:8:\"standard\";}',5);";
 $Inserts[27] = "INSERT INTO {dbprefix}config (config_key, config_value, value_type) VALUES ('locales','a:0:{}',5)";