Tobias Bartel wrote:
> Hello,
>
>   
>> Even with 800,000 files, that sounds very slow.  How much data is
>> involved, how is it stored and how fast is your database server?
>>     
>
> It's about 70GB of data, stored on a Raid5 (3Ware controller).
>
> The database is a SQLite one, on the same machine but on a Software 
> Raid 1.
>   
You obviously have a very performance-sensitive situation, and writing 
to a software raid can seriously affect performance. Any chance you can 
move the database to a hardware RAID? For that matter, ideally I would 
recommend completely eliminating the software raid from that machine if 
you can, or at least only put read-only data on it, such as the /usr 
directory.

-- 
Kevin Keane
Owner
The NetTech
Turn your NetWORRY into a NetWORK!

Office: 866-642-7116
http://www.4nettech.com

This e-mail and attachments, if any, may contain confidential and/or 
proprietary information. Please be advised that the unauthorized use or 
disclosure of the information is strictly prohibited. The information herein is 
intended only for use by the intended recipient(s) named above. If you have 
received this transmission in error, please notify the sender immediately and 
permanently delete the e-mail and any copies, printouts or attachments thereof.


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users