-----Original Message-----
From: Dimitri Maziuk <dmaziuk AT bmrb.wisc DOT edu>
To: bacula-users AT lists.sourceforge DOT net
Subject: Re: [Bacula-users] SQLite
Date: Wed, 29 Apr 2015 10:12:53 -0500
Mailer: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101
Thunderbird/31.6.0

On 2015-04-29 08:58, Matt Ivie wrote:

> Any input on the topic is appreciated.

http://www.sqlite.org/howtocorrupt.html

The size of the database is determined by the number of files and 
retention periods. IRL the most likely corruption scenario is the disk 
going bad, so size doesn't matter. Where it does matter is performance: 
with a large catalog postgres's query optimizer can make a lot of 
difference.

Dimitri


------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Thank you Dimitri, your explanation makes perfect sense and puts me at
ease to continue using SQLite with bacula.

Matt




------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users