Remove indicies based on dp_pending.taken

The cost of maintaining the index kills performance.

2 files changed, 3 insertions, 4 deletions

diff --git a/rtss14/createtables.sql b/rtss14/createtables.sql
index f3371e4..4949362 100644
--- a/rtss14/createtables.sql
+++ b/rtss14/createtables.sql
@@ -86,8 +86,8 @@ CREATE TABLE dp_pending(
         chunk_size       INT UNSIGNED,
 
         PRIMARY KEY (id),
-        INDEX (id, taken),
-        INDEX (taken),
+--      INDEX (id, taken),
+--      INDEX (taken),
         INDEX (ts_util),
         INDEX (cpu_cluster_size, gpu_cluster_size, is_worst_case, is_polluters, util_dist, period_dist, data_dist, state_dist, kernel_dist, cpu_dist, gpu_population, rho, is_dgl, is_p2p, ncopy_engines, chunk_size)
         -- every permutation marks a unique configuration
diff --git a/rtss14/database.py b/rtss14/database.py
index f445ab2..3a1ba50 100755
--- a/rtss14/database.py
+++ b/rtss14/database.py
@@ -274,8 +274,7 @@ def __repair_design_points(conn):
     c.execute('UPDATE dp_pending AS P '
               'JOIN   dp_ptested AS T ON %s '
               'JOIN   sched_results as R ON P.ts_util=R.ts_util AND T.id=R.dp '
-              'SET    P.taken=0 '
-              'WHERE  P.taken<>0' %
+              'SET    P.taken=0 ' %
                 ' AND '.join(map(lambda x: 'P.%s=T.%s' % (x,x), [d for d in dp_col_names if d != 'ts_util'])) )
     nrepaired = c.rowcount
     c.close()