[pLog-svn] r3405 - plog/trunk/install

oscar at devel.lifetype.net oscar at devel.lifetype.net
Sat May 13 15:59:18 GMT 2006


Author: oscar
Date: 2006-05-13 15:59:17 +0000 (Sat, 13 May 2006)
New Revision: 3405

Modified:
   plog/trunk/install/dbschemas.properties.php
Log:
another extremely useful index, went from a full table scan to just a few rows.


Modified: plog/trunk/install/dbschemas.properties.php
===================================================================
--- plog/trunk/install/dbschemas.properties.php	2006-05-13 15:54:41 UTC (rev 3404)
+++ plog/trunk/install/dbschemas.properties.php	2006-05-13 15:59:17 UTC (rev 3405)
@@ -20,7 +20,8 @@
   INDEX user_id (user_id),
   INDEX slug (slug),
   INDEX blog_id_status_date (blog_id, status, date),
-  INDEX global_category_status (global_category_id, status)  
+  INDEX global_category_status (global_category_id, status),
+  INDEX date(date)
 ";
 $Tables["articles"]["options"] = "TYPE=MyISAM";
 



More information about the pLog-svn mailing list