Sebastian Stark wrote: > As far as I understand the SQLite interface shouldn't be used in > production environments. You should get better performance by > switching to MySQL or PostgreSQL. >
So I switched bacula from sqlite to mysql today. Elapsed time: 1 hour 12 mins 49 secs Priority: 10 FD Files Written: 219,369 SD Files Written: 219,369 FD Bytes Written: 27,011,878,356 (27.01 GB) SD Bytes Written: 27,042,704,440 (27.04 GB) Rate: 6182.6 KB/s Software Compression: 15.5 % MUCH better! I wish I had done this months ago. However it still doesn't add up. I just don't see how sqlite can be 20 times slower than MySQL. I would expect it to be faster since it is so much simpler. I really liked sqlite because there is no daemon to make sure is running, no way anyone could access it from outside, and it can be set up very quickly. I will stick with mysql for now but I strongly suspect a problem in the bacula->sqlite interface. -- Tracy R Reed http://ultraviolet.org _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
