Subject Re: [firebird-support] FW and Journaling
Author Hannes Streicher
Guten Tag Andrea Raimondi,

Journaling will only save what is written to disk,
Forced Writes will make sure it gets written,

so if your computer crashes journaling will leave you with a broken database


>
> I would always go for journalling on, it is in my opinion safer overall.

> A




> On Sat, Sep 28, 2013 at 3:23 PM, Carlos H. Cantu <listas@...> wrote:
>
> It is well known that the writing performance of FB databases on
> linux, when you have Forced Writes ON and the filesystem has the
> journaling parameter active is horrible and almost unusable if you
> have lots of writing (or even worse, massive/batch updates).
>
> Question is:
>
> What would be safer:
>
> Keep FW OFF and Journaling ON
> or
> Keep FW ON and Journaling OFF
> ?
>
> []s
> Carlos
> Firebird Performance in Detail - http://videos.firebirddevelopersday.com
> www.firebirdnews.org - www.FireBase.com.br
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>





--
Mit freundlichen GrĂ¼ssen
Hannes Streicher mailto:HStreicher@...