Re: [Bacula-users] Req: restore 2 slow, CREATE INDEX FilenameId ON File(FilenameId);

2014-02-14 Thread Eric Bollengier
Hello Hans, On 02/11/2014 01:32 PM, Hans Schou wrote: > Hi > > When going into restore: >2: List Jobs where a given File is saved > it takes quite a lot of time to get the list. > > To speed it up I have added an index: >CREATE INDEX FilenameId ON File(FilenameId); > > Am I doing someth

[Bacula-users] Req: restore 2 slow, CREATE INDEX FilenameId ON File(FilenameId);

2014-02-11 Thread Hans Schou
Hi When going into restore: 2: List Jobs where a given File is saved it takes quite a lot of time to get the list. To speed it up I have added an index: CREATE INDEX FilenameId ON File(FilenameId); Am I doing something wrong or could this be added to futufre releases (and then what will b