On 30/09/2013 10:53, Kjell Rilbe wrote: > Den 2013-09-28 16:23 skrev Carlos H. Cantu såhär: >> What would be safer: >> >> Keep FW OFF and Journaling ON >> or >> Keep FW ON and Journaling OFF > > I*m going to suggest something unorthodox: if you have performance > issues, turn off both journaling and forced writes, and insteasd opt for > a tight backup schedule and/or RAID and/or b attery backed-up disk > controllers etc. <snip> > For us, we have a dedicated server where they (the service provider) > have power backups and we also have the database on a RAID 1 volume. We > have forced writes off and do nightly backups to a remote secure backup > volume. The likelyhood of a crash is low enough that we can accept to > lose on day's worth of updates in the unlikely case it happens. We are > considering some NBackup solution with somewhat tighter higher-level > backups, but haven't gone through with it yet.
Interesting. As posted before, replication could give you a copy which could be used for queries as well. If I may ask, why are you looking at NBackup versus a replication solution? Ease of use/setup? Or perhaps you intend to use nbackup to perform the backup and restore it to a different host? AFAIR you're dealing with huge amounts of data so I assume you don't? Thanks! ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://info.yahoo.com/legal/us/yahoo/utos/terms/