X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=geni%2Futil%2Fgenitable.py;h=7de2b4b88f69490dcc26153e0ac5269d5405e52d;hb=d0209f3bb815b102304638338d2e4cca90d7e0cd;hp=36d40e9788099dc6734f4c2343b52c20c7793bf5;hpb=ca070e405851d591db34e47bc9669973756639ec;p=sfa.git

diff --git a/geni/util/genitable.py b/geni/util/genitable.py
index 36d40e97..7de2b4b8 100644
--- a/geni/util/genitable.py
+++ b/geni/util/genitable.py
@@ -37,13 +37,16 @@ class GeniTable():
         return False
 
     def create(self):
+        
         querystr = "CREATE TABLE " + self.tablename + " ( \
                 key text, \
                 name text, \
                 gid text, \
                 type text, \
                 pointer integer);"
-
+        template = "CREATE INDEX %s_%s_idx ON %s (%s);"
+        indexes = [template % ( self.tablename, field, self.tablename, field) \
+                   for field in ['name', 'type' ]]
         # IF EXISTS doenst exist in postgres < 8.2
         try:
             self.cnx.query('DROP TABLE IF EXISTS ' + self.tablename)
@@ -54,6 +57,8 @@ class GeniTable():
                 pass
         
         self.cnx.query(querystr)
+        for index in indexes:
+            self.cnx.query(index)
 
     def remove(self, record):
         query_str = "DELETE FROM " + self.tablename + " WHERE key = '" + record.get_key() + "'"