Re: Lost Records in Database
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39526
interpreted = N
texte = >On 23.10.2001 4:00 PM, Christer Olsson
wrote:>> >> Unfortunately, this is NOT the orders.db file. I'm currently> >> manually backing up the file every 6 hours, but this may still cause> >> records to be lost.> >>> >> Smith Micro: any ideas???> >> > I'm not SMSI, but loosing data from a RAM based database is somewhat the> > natural thing in a crash. If the data hasn't been written to disk, it's of> > course lost.> >> > If you can't afford to loose any data you must make sure it is >written to disk> > every time it has changed.>>Right, for that I have after every append or replace a closedatabase tag.>This gives some overhead to the server, but as John mentioned you need to>investigate into other Server options. 10.1 for one is quite good.I hope you mean [COMMITDATABASE] :-)-- ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Idéer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se-------------------------------------------------------------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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>On 23.10.2001 4:00 PM, Christer Olsson wrote:>> >> Unfortunately, this is NOT the orders.db file. I'm currently> >> manually backing up the file every 6 hours, but this may still cause> >> records to be lost.> >>> >> Smith Micro: any ideas???> >> > I'm not SMSI, but loosing data from a RAM based database is somewhat the> > natural thing in a crash. If the data hasn't been written to disk, it's of> > course lost.> >> > If you can't afford to loose any data you must make sure it is >written to disk> > every time it has changed.>>Right, for that I have after every append or replace a closedatabase tag.>This gives some overhead to the server, but as John mentioned you need to>investigate into other Server options. 10.1 for one is quite good.I hope you mean [commitdatabase] :-)-- ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Idéer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se-------------------------------------------------------------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://search.smithmicro.com/
Christer Olsson
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:
[FoundItems] solved - thanks (1997)
Emailer (WebCat2) (1997)
Loosing Quantity (2000)
attachment (2000)
[SearchString] usage (1997)
bug in [SendMail] (1997)
Revisit: speed test (2002)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
upgrading (1997)
Re1000001: Setting up shop (1997)
PIXO support (1997)
OH CRAP!!!!!- Template not found error!!! (1999)
three cart questions (1997)
restarting service remotely on NT (1997)
flushdatabases (1997)
[WebDNA] Putting '&search' into URL killing all search contexts on my sites (2010)
New Command prefs ... (1997)
Re:PCS Customer submissions ? (1997)
Database Structure? (1998)
Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)