You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by ag...@apache.org on 2006/12/06 20:51:59 UTC
svn commit: r483200 -
/incubator/roller/trunk/metadata/database/310-to-320-migration.vm
Author: agilliland
Date: Wed Dec 6 11:51:58 2006
New Revision: 483200
URL: http://svn.apache.org/viewvc?view=rev&rev=483200
Log:
a few more indexes to improve query performance.
Modified:
incubator/roller/trunk/metadata/database/310-to-320-migration.vm
Modified: incubator/roller/trunk/metadata/database/310-to-320-migration.vm
URL: http://svn.apache.org/viewvc/incubator/roller/trunk/metadata/database/310-to-320-migration.vm?view=diff&rev=483200&r1=483199&r2=483200
==============================================================================
--- incubator/roller/trunk/metadata/database/310-to-320-migration.vm (original)
+++ incubator/roller/trunk/metadata/database/310-to-320-migration.vm Wed Dec 6 11:51:58 2006
@@ -30,3 +30,6 @@
-- some various indexes to improve performance
create index rhc_dailyhits_idx on roller_hitcounts( dailyhits );
+create index we_combo1_idx on weblogentry(status, pubtime, websiteid);
+create index we_combo2_idx on weblogentry(websiteid, pubtime, status);
+create index rc_combo1_idx on roller_comment(approved, spam, posttime);