for a 2,500,000 file-job my machine needs ~ 15 minutes
the databasequery is finished after ~1 minute,
but the director needs 14 minutes to build the tree or whatever happens
in this time .....
also is the dir only using one cpu for his work, instead of four.
i don't think that the database is the problem.
Regards
Thomas
Alan Brown schrieb:
> On Tue, 9 Jan 2007, Ondrej PLANKA wrote:
>
>>> It sounds silly, but add individual indexes for JobId, PathId and FilnameId
>>> as well as the 3-way one.
>>>
>> Ok, do you have some tip, how can I add individual indexes? Because I think,
>> my indexes are OK or not?
>
> ALTER TABLE File ADD INDEX [name] {column} ;
>
> so...
>
> ALTER TABLE File ADD INDEX file_jobid_idx JobId ;
> ALTER TABLE File ADD INDEX file_pathid_idx PathId ;
> ALTER TABLE File ADD INDEX file_filenameid_idx FilenameId ;
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
--
IC3S Information, Computer und Solartechnik AG
Bäckerbarg 6, 22889 Tangstedt, Germany
Telefon +49.4109.555.121
Telefax +49.4109.555.57
E-Mail [EMAIL PROTECTED]
Web http://www.ic3s.de/
Vorstand: Jan Behrmann (Vorsitzender), Stefan Fehlauer
Aufsichtsrat: Sven Niklasson (Vorsitzender)
Dresdner Bank (200 800 00), Kto. 0123 9582 00
Commerzbank (200 400 00), Kto. 8540 288
Amtsgericht Kiel HRB 7590
UST.IdNr. DE184532766
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
