Eduardo. You problem only will be solved by turning on write cache if possible or switching to a new cache write enabled server. Dot. Do not change anything in your software. Em 30/12/2015 12:15, "Eduardo [email protected] [firebird-support]" < [email protected]> escreveu:
> > > I read that disabling forced writes is not safe. > > But there is something that I really don´t understand. > > If I disable forced writes, then when I make commits, data goes to the RAM > of the server and afterwards, in some moment, the data will be physically > written to the database. > > If I enable disk write cache, then things happen the same way. So, what is > the difference? > > From what I read, I think the difference is that with disk write cache, > Windows manages when to physically write the data but, when disabling > forced writes it is not guaranteed that Windows will physically write the > data. Is this true? > > Another question. Why is so different the performance with disk write > cache enabled or disabled? Is this something that happens in every RDBMS or > is just a Firebird problem? > > Regards > > Eduardo > > -------- Mensaje original -------- > *Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows > Server 2012 > *De: *Ann Harrison [email protected] [firebird-support] > <[email protected]> <[email protected]> > *Para: *[email protected] > <[email protected]> <[email protected]> > *Fecha: *29/12/2015 17:26 > > > On Tue, Dec 29, 2015 at 2:44 PM, Macma [email protected] [firebird-support] < > [email protected]> wrote: > >> >> >> Do I have to change any configuration or the matter is that if I can´t >> enable disk cache, there is nothing I can do to improve the performance? >> >> Try to disable force write on that database. >> > > After you have a UPS installed and an aggressive backup schedule. > > Good luck, > > Ann > > > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> > Este > correo electrónico se ha enviado desde un equipo libre de virus y protegido > por Avast. > www.avast.com > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> > >
