Re: [Bacula-devel] indexes on File - make_mysql_tables vs docs

2013-02-03 Thread Kern Sibbald
Hello James, Logically we want things returned in PathId, FilenameId order, and I just noticed that Eric updated the documentation to specify Jobid, PathId, FilenameId, so that is what I would recommend. Best regards, Kern On 02/03/2013 10:07 AM, Kern Sibbald wrote: > On 02/02/2013 11:18 PM, Jam

Re: [Bacula-devel] indexes on File - make_mysql_tables vs docs

2013-02-03 Thread Kern Sibbald
On 02/02/2013 11:18 PM, James Harper wrote: > The manual here > http://www.bacula.org/5.2.x-manuals/en/main/main/Catalog_Maintenance.html#SECTION004292000 > says I should create an index on File of (JobId, FilenameId, PathId), while > the make_mysql_tables script says it should be (J

Re: [Bacula-devel] indexes on File - make_mysql_tables vs docs

2013-02-03 Thread Eric Bollengier
Hello James, On 02/02/2013 11:18 PM, James Harper wrote: > The manual here > http://www.bacula.org/5.2.x-manuals/en/main/main/Catalog_Maintenance.html#SECTION004292000 > says I should create an index on File of (JobId, FilenameId, PathId), > while the make_mysql_tables script says it s

[Bacula-devel] indexes on File - make_mysql_tables vs docs

2013-02-02 Thread James Harper
The manual here http://www.bacula.org/5.2.x-manuals/en/main/main/Catalog_Maintenance.html#SECTION004292000 says I should create an index on File of (JobId, FilenameId, PathId), while the make_mysql_tables script says it should be (JobId, PathId, FilenameId). Which is it? Thanks Ja