From 4b18a6602ebbe104625034aea3a113ec00e8ce56 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Sun, 18 Oct 2015 11:35:37 +0200 Subject: [PATCH] Enhance bvfs performance .bvfs_update for MySQL Bug reported here: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=737821 Conflicts: bacula/src/cats/bvfs.c --- bacula/src/cats/bvfs.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/bacula/src/cats/bvfs.c b/bacula/src/cats/bvfs.c index 1d4619d32e..403f063c8d 100644 --- a/bacula/src/cats/bvfs.c +++ b/bacula/src/cats/bvfs.c @@ -482,7 +482,7 @@ static int update_path_hierarchy_cache(JCR *jcr, "AND h.PPathId NOT IN (SELECT PathId FROM PathVisibility WHERE JobId=%s)", jobid, jobid, jobid ); - } else if (mdb->bdb_get_type_index() == SQL_TYPE_MYSQL) { + } else if (mdb->bdb_get_type_index() == SQL_TYPE_MYSQL) { Mmsg(mdb->cmd, "INSERT INTO PathVisibility (PathId, JobId) " "SELECT a.PathId,%s " @@ -494,7 +494,7 @@ static int update_path_hierarchy_cache(JCR *jcr, "LEFT JOIN PathVisibility AS b ON (b.JobId=%s and a.PathId = b.PathId) " "WHERE b.PathId IS NULL", jobid, jobid, jobid); - } else { /* TODO: Test the MYSQL Query with PostgreSQL */ + } else { Mmsg(mdb->cmd, "INSERT INTO PathVisibility (PathId, JobId) " "SELECT a.PathId,%s " -- 2.39.2