[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