From 5c0ccd818c152cd426780e4bc55798f1d10dde04 Mon Sep 17 00:00:00 2001 From: Sofia Papagiannaki Date: Thu, 8 Sep 2011 16:26:15 +0300 Subject: [PATCH] Alchemy module: change index on versions table. Refs: #1075 --- pithos/backends/lib_alchemy/node.py | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) diff --git a/pithos/backends/lib_alchemy/node.py b/pithos/backends/lib_alchemy/node.py index 7bd5210..716f94c 100644 --- a/pithos/backends/lib_alchemy/node.py +++ b/pithos/backends/lib_alchemy/node.py @@ -149,10 +149,8 @@ class Node(DBWorker): columns.append(Column('muser', String(255), nullable=False, default='')) columns.append(Column('cluster', Integer, nullable=False, default=0)) self.versions = Table('versions', metadata, *columns) - # place an index on node - Index('idx_versions_node', self.versions.c.node) - # TODO: Sort out if more indexes are needed. - #Index('idx_versions_node', self.versions.c.mtime) + Index('idx_versions_node_mtime', self.versions.c.node, + self.versions.c.mtime) #create attributes table columns = [] -- 1.7.10.4