Re: db not being written to disk

This WebDNA talk-list message is from

2003

It keeps the original formatting. numero = 53900
interpreted = N
texte = It happend to us several times too - remember to flush databases beforeyou shutdown/restart. You could make a trigger that flushes databasesonce a hour (or more). Then you can limit the amount of data that willbe lost during server breakdown.I'm not an experts but i would think as long as the data only exists inthe ram - it is at risk of being lost. We lost data (whole day ofwork/transactions) on account of a power failure etc. So now we run withat MS SQL SERVER 2000 and since we changes system never lost any data(Wuuuhuuu)... AND we have a REAL relationaldatabasesystem. Hard to livewith out it...Kind regardsMorten-----Original Message-----From: Vincent Medina [mailto:vmedina@apcn.net]Sent: 7. november 2003 19:01To: WebDNA TalkSubject: db not being written to diskWC Version is Windows EXE version 4.0.2 running on Deerfield Website3.1.I have had this happened to me on a few occasions:The power would go out beyond the capacity of our power backups so Iwould initiate a shutdown of all my servers. When I power up the WebsiteServer the data within the db's prior to shutdown reverts back to anolder version. It seems like the db's are not being written to disk orperiodically are being written to disk. Should I be committing mydatabases every time I do an [append]?Vincent MedinaAPC Net, Inc.-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: db not being written to disk ( Scott Anderson 2003) Re: db not being written to disk ( "Morten Madsen" 2003) db not being written to disk ( "Vincent Medina" 2003)

It happend to us several times too - remember to flush databases beforeyou shutdown/restart. You could make a trigger that flushes databasesonce a hour (or more). Then you can limit the amount of data that willbe lost during server breakdown.I'm not an experts but i would think as long as the data only exists inthe ram - it is at risk of being lost. We lost data (whole day ofwork/transactions) on account of a power failure etc. So now we run withat MS SQL SERVER 2000 and since we changes system never lost any data(Wuuuhuuu)... AND we have a REAL relationaldatabasesystem. Hard to livewith out it...Kind regardsMorten-----Original Message-----From: Vincent Medina [mailto:vmedina@apcn.net]Sent: 7. november 2003 19:01To: WebDNA TalkSubject: db not being written to diskWC Version is Windows EXE version 4.0.2 running on Deerfield Website3.1.I have had this happened to me on a few occasions:The power would go out beyond the capacity of our power backups so Iwould initiate a shutdown of all my servers. When I power up the WebsiteServer the data within the db's prior to shutdown reverts back to anolder version. It seems like the db's are not being written to disk orperiodically are being written to disk. Should I be committing mydatabases every time I do an [append]?Vincent MedinaAPC Net, Inc.-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ "Morten Madsen"

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

bug ? causes NT event log to fill (1997) Web Catalog 2 demo (1997) Generating Pages (1999) WebCatalog for Postcards ? (1997) [WebDNA] 6.2 Monitor (2012) PCS Frames (1997) Cant open pages generated by Webcat (2004) WebCommerce: Folder organization ? (1997) Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997) searchable list archive (1997) webcat 2.1 (1997) Interesting speed comparison .. (2003) WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997) supressing math results (1997) multiple search commands (1997) [LOOKUP] (1997) Sorting error (1997) Carts & cookies (1999) Re:Searching for ALL / empty form field (1997) price on detail, but not shoppingcart (1997)