roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From agillil...@apache.org
Subject svn commit: r483200 - /incubator/roller/trunk/metadata/database/310-to-320-migration.vm
Date Wed, 06 Dec 2006 19:51:59 GMT
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);



Mime
View raw message