Re: [Bacula-devel] Schema patch

2017-08-06 Thread Kern Sibbald
Hello Phil, Thank you for your comments, and I am pleased that you have found a solution for your batch insert problem. Unfortunately, I cannot apply the patch to a released version two days before I go on vacation. Nor will I change the default. If you can show me solid statistics on a Li

Re: [Bacula-devel] Regarding the batch size and attribute spooling

2017-08-06 Thread Kern Sibbald
Phil, I repeat here my previous email message which refers to your email below, but I mistakenly attached to your schema email. Sorry for the repetition. Hello Phil, Thank you for your comments, and I am pleased that you have found a solution for your batch insert problem.

Re: [Bacula-devel] Schema patch

2017-08-06 Thread Kern Sibbald
Phil, Here is my response concerning the mysql_tables_change (see your email below). I cannot make changes of the kind that you suggest where some change items that are not broken or items where I cannot reproduce a problem. This is especially since this is a production release, which I can

Re: [Bacula-devel] Schema patch

2017-08-06 Thread Phil Stracchino
On 08/06/17 03:24, Kern Sibbald wrote: > Hello Phil, > > Thank you for your comments, and I am pleased that you have found a > solution for your batch insert problem. Unfortunately, I cannot apply > the patch to a released version two days before I go on vacation. Nor > will I change the defa

[Bacula-devel] Spoke too soon on BAT

2017-08-06 Thread Phil Stracchino
Just a heads-up ... I spoke too soon, BAT still sometimes becomes unresponsive when purging volumes. It's not at all clear to me why except that it seems to be related to multiple pop-up notifications. I still strongly suspect the problem is one of multiple simultaneous app-modal dialogs. --

Re: [Bacula-devel] Spoke too soon on BAT

2017-08-06 Thread Phil Stracchino
On 08/06/17 13:36, Phil Stracchino wrote: > Just a heads-up ... I spoke too soon, BAT still sometimes becomes > unresponsive when purging volumes. It's not at all clear to me why > except that it seems to be related to multiple pop-up notifications. I > still strongly suspect the problem is one

Re: [Bacula-devel] Schema patch

2017-08-06 Thread Ulrich Leodolter
Hi Phil, > Phil Stracchino hat am 6. August 2017 um 17:03 > geschrieben: > > Community request: > Does anyone else here have a test environment which DOES have jobs of > that size who could perform comparison tests of the same 20-50 million > file backup job with and without batch insert? We h

Re: [Bacula-devel] Schema patch

2017-08-06 Thread Phil Stracchino
On 08/06/17 13:47, Ulrich Leodolter wrote: > Hi Phil, > >> Phil Stracchino hat am 6. August 2017 um 17:03 >> geschrieben: >> >> Community request: >> Does anyone else here have a test environment which DOES have jobs of >> that size who could perform comparison tests of the same 20-50 million >>

Re: [Bacula-devel] Schema patch

2017-08-06 Thread Kern Sibbald
Hello Ulrich, I obviously would be interested in seeing the statistics, and unless you take some precautions I would strongly suggest not running it on a production environment. If you do, nevertheless, want to try, at a minimum, I would create a new database (named perhaps TestBacula. Then