From a0ccb9ebfe86f237e48368b9b9f263e61ebc0734 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Fri, 15 May 2009 19:39:36 +0000 Subject: [PATCH] ebl add index on temporary table to speed up mysql part during restore git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@8833 91ce42f0-d328-0410-95d8-f526ca767f89 --- gui/bweb/cgi/bresto.pl | 1 + 1 file changed, 1 insertion(+) diff --git a/gui/bweb/cgi/bresto.pl b/gui/bweb/cgi/bresto.pl index 6984057439..863b915cab 100755 --- a/gui/bweb/cgi/bresto.pl +++ b/gui/bweb/cgi/bresto.pl @@ -873,6 +873,7 @@ SELECT max(JobId) as JobId, PathId, FilenameId, FileIndex GROUP BY PathId, FilenameId HAVING FileIndex > 0 )"); + $bvfs->dbh_do("CREATE INDEX btemp2_idx ON btemp2 (JobId, PathId, FilenameId)"); $bvfs->dbh_do("CREATE TABLE b2$$ AS ( SELECT btemp.JobId, btemp.FileIndex, btemp.FilenameId, btemp.PathId FROM btemp, btemp2 -- 2.39.5