Bruno Friedmann wrote:
> Olivier Delestre wrote:
>> Pour infos, le dernier ordre sql ( buildind tree ) emis lors d'un
>> restore->choix 5 sous la console :
>>
>> SELECT Path.Path, Filename.Name, File.FileIndex, File.JobId, File.LStat
>> FROM ( SELECT max(FileId) as FileId, PathId, FilenameId
>> FROM ( SELECT FileId, PathId, FilenameId
>> FROM File
>> WHERE JobId IN (4032,4072))
>> AS F GROUP BY PathId, FilenameId )
>> AS Temp JOIN Filename ON (Filename.FilenameId = Temp.FilenameId)
>> JOIN Path ON (Path.PathId = Temp.PathId)
>> JOIN File ON (File.FileId = Temp.FileId) WHERE File.FileIndex > 0
>> ORDER BY JobId, FileIndex ASC
>>
>> A+
>>
>
> Je teste demain la même requète sur un équivalent de jobs.
>
>
Voilà ici cela donne ça comme résultats par exemple
SELECT Path.Path, Filename.Name, File.FileIndex, File.JobId, File.LStat
FROM ( SELECT max(FileId) as FileId, PathId, FilenameId
FROM ( SELECT FileId, PathId, FilenameId
FROM File
WHERE JobId IN (3623,3624,3625,3626))
AS F GROUP BY PathId, FilenameId )
AS Temp JOIN Filename ON (Filename.FilenameId = Temp.FilenameId)
JOIN Path ON (Path.PathId = Temp.PathId)
JOIN File ON (File.FileId = Temp.FileId) WHERE File.FileIndex > 0
ORDER BY JobId, FileIndex ASC
--
--| 3,623 | Job-FileWeekly | 2009-10-03 03:30:30 | B | F
| 780,816 | 148,344,914,108 | T |
--| 3,624 | Job-FileWeekly_Archives | 2009-10-03 07:00:03 | B | F
| 976,381 | 278,078,056,146 | T |
--| 3,625 | Job-FileWeekly_Images | 2009-10-03 11:00:01 | B | F
| 492,468 | 48,575,050,311 | T |
--| 3,626 | Job-FileWeekly_Utils | 2009-10-03 15:00:03 | B | F
| 237,879 | 80,251,268,579 | T |
-- 2 487 544 Files
-- 555 249 289 144 Bytes
38 minutes pour avoir la liste
Mais la machine reste stable, et fonctionnelle ( load d'environ 2 à 3 )
--
Bruno Friedmann
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Bacula-users-fr mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users-fr
