roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From agillil...@apache.org
Subject svn commit: r482265 - in /incubator/roller/trunk/metadata/database: 310-to-320-migration.vm createdb.vm
Date Mon, 04 Dec 2006 17:55:54 GMT
Author: agilliland
Date: Mon Dec  4 09:55:53 2006
New Revision: 482265

URL: http://svn.apache.org/viewvc?view=rev&rev=482265
Log:
add an index on roller_hitcounts.dailyhits column which improves performance on the getHotBlogs
query.


Modified:
    incubator/roller/trunk/metadata/database/310-to-320-migration.vm
    incubator/roller/trunk/metadata/database/createdb.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=482265&r1=482264&r2=482265
==============================================================================
--- incubator/roller/trunk/metadata/database/310-to-320-migration.vm (original)
+++ incubator/roller/trunk/metadata/database/310-to-320-migration.vm Mon Dec  4 09:55:53 2006
@@ -26,3 +26,7 @@
     #addColumnNull("folder" "path" "varchar(1000)")
 #end
 create index fo_path_idx on folder( path$!INDEXSIZE );
+
+
+-- some various indexes to improve performance
+create index rhc_dailyhits_idx on roller_hitcounts( dailyhits );

Modified: incubator/roller/trunk/metadata/database/createdb.vm
URL: http://svn.apache.org/viewvc/incubator/roller/trunk/metadata/database/createdb.vm?view=diff&rev=482265&r1=482264&r2=482265
==============================================================================
--- incubator/roller/trunk/metadata/database/createdb.vm (original)
+++ incubator/roller/trunk/metadata/database/createdb.vm Mon Dec  4 09:55:53 2006
@@ -402,6 +402,7 @@
     dailyhits	    integer
 );
 create index rhc_websiteid_idx on roller_hitcounts( websiteid );
+create index rhc_dailyhits_idx on roller_hitcounts( dailyhits );
 
 -- Entry attribute: metadata for weblog entries
 create table entryattribute (



Mime
View raw message