Re: Lost Records in Database
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39524
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.Sincerely Nitai-- Tools to energize business Content Management & eBusiness SystemsComputerOil GmbH http://computeroil.com/ Hauptstrasse 12 info@computeroil.com 8252 Schlatt/Switzerland Tel: +41 (0)52 654 15 55 ------------------------------------------------------------- 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.Sincerely Nitai-- Tools to energize business Content Management & eBusiness SystemsComputerOil GmbH http://computeroil.com/ Hauptstrasse 12 info@computeroil.com 8252 Schlatt/Switzerland Tel: +41 (0)52 654 15 55 ------------------------------------------------------------- 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/
Nitai @ ComputerOil
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:
[WebDNA] Filtering exact numbers (2008)
WebCatalog can't find database (1997)
Database Updates (1997)
[WebDNA] Accepting Payments on Site (2013)
form data submission gets truncated (1997)
More news on 5.0 (2003)
forms and variables (1998)
Passwords, Subscription, DBs, oh my! (2000)
same product in cart (1997)
Sku numbers (1997)
[encrypt] blues.... (2000)
WebMerchant -- Sweeping WebDelivery < 24 hrs (2000)
New Lawsuit Alleges Unitedhealth/Pacificare Deceived (2006)
Is this possible, WebCat2.0 and checkboxes (1997)
Error Log.db --however (1997)
TCPSEND (1999)
hideif [x]=1,2,3.. (2003)
Max Record length restated as maybe bug (1997)
Sorting search results (1998)
International Orders (1998)