Den 2012-03-10 07:29 skrev Leyne, Sean såhär: > > > > > I know it's risky, but I am willing to take the risk to gain > performance, so > > we've got forced writes off on our database on Windows > > 2008 server (web edition). > > > > I was wondering if this still holds true for Windows 2008, as cited from > > http://www.firebirdsql.org/manual/qsg10-howtocorrupt.html: > > > > "It has been observed that the Windows server platforms do not flush the > > write cache until the Firebird service is shut down." > > > > Asking just to be aware of the level of risk I'm exposed to. > > I am not aware of any change/difference between these versions, and I > ***never*** run with FORCED WRITES = OFF -- the risk is ***never*** > worth it. > > If you want performance, invest in a top level RAID controller (LSI) > and/or Enterprise SSD based storage. >
I am aware of this and the investments are in the pipe. In the meantime it's ok for this application to simply do a nightly backup. Losing one day's work at a rather low risk is fine. The server is hosted with good power backups etc and the server has been stable so far and is not running much else. Kjell -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: [email protected] Telefon: 08-761 06 55 Mobil: 0733-44 24 64 [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
