From 7e84da5fef77ffaa1b7462b7eb647e48d8c5613c Mon Sep 17 00:00:00 2001
From: Matthias Beyer <matthias.beyer@atos.net>
Date: Fri, 9 Apr 2021 11:32:35 +0200
Subject: Optimize: Only load the job ids from the DB in the first place

Signed-off-by: Matthias Beyer <matthias.beyer@atos.net>
---
 src/commands/db.rs | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

(limited to 'src/commands/db.rs')

diff --git a/src/commands/db.rs b/src/commands/db.rs
index d8669aa..a8d8b3c 100644
--- a/src/commands/db.rs
+++ b/src/commands/db.rs
@@ -331,9 +331,8 @@ fn jobs(conn_cfg: DbConnectionConfig, matches: &ArgMatches) -> Result<()> {
                     .and(schema::envvars::dsl::value.eq(val))
             })
             .inner_join(schema::job_envs::table)
-            .select(schema::job_envs::all_columns)
-            .load::<models::JobEnv>(&conn)
-            .map(|jobenvs| jobenvs.into_iter().map(|je| je.job_id).collect::<Vec<_>>())?;
+            .select(schema::job_envs::job_id)
+            .load::<i32>(&conn)?;
 
         sel.filter(schema::jobs::dsl::id.eq_any(jids))
     } else {
-- 
cgit v1.2.3