Re: Disappearing data
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43013
interpreted = N
texte = >We started having a number of random problems:>> - Frequent WebDNA service shut downs>>Tim, if your WebDNA crashes you have a chance of loosing>any new data that has not been written to the hard disk.>Make sure your databases are committed often enough.This will not solve the problem if the RAM-cached data gets screwed up and then WebDNA writes that bad data to disk thereby overwriting the 'good' data that was stored on disk. The only real solution to this problem is to duplicate your db files at periodic intervals, and then preferably to store those duplicates offline or on another volume.>We have 1500 products or so in our main store and>haven't lost a single character.>Site has been running for approx. 8 months or so now.>MacOS - 4.51500 products is a very small db compared to the db's some other people are using. And this problem may also be related to how busy the store is. It may just be that you will never see the same problems others are experiencing -- until your db gets big enough to start creating those problems, or until your store gets so busy that ot severely taxes webcat's ability to keep up with the traffic.I would tend to think that this data loss problem may have something to do with how much RAM is available for the webcat db's to reside in. If RAM is too limited then webcat has to perform repetitive db swaps into and out of memory. If this is happening a lot, especially on a busy site, it seems like there would be a much higher chance for data corruption (since there's far more writing of data to disk) than on a site that never has to swap db's into and out of RAM ...Sincerely,Kenneth Grome---------------------------------------------------WebDNA Professional Training and Development Center175 J. Llorente Street +63 (32) 255-6921Cebu City, Cebu 6000 kengrome@webdna.netPhilippines http://www.webdna.net----------------------------------------------------------------------------------------------------------------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:
>We started having a number of random problems:>> - Frequent WebDNA service shut downs>>Tim, if your WebDNA crashes you have a chance of loosing>any new data that has not been written to the hard disk.>Make sure your databases are committed often enough.This will not solve the problem if the RAM-cached data gets screwed up and then WebDNA writes that bad data to disk thereby overwriting the 'good' data that was stored on disk. The only real solution to this problem is to duplicate your db files at periodic intervals, and then preferably to store those duplicates offline or on another volume.>We have 1500 products or so in our main store and>haven't lost a single character.>Site has been running for approx. 8 months or so now.>MacOS - 4.51500 products is a very small db compared to the db's some other people are using. And this problem may also be related to how busy the store is. It may just be that you will never see the same problems others are experiencing -- until your db gets big enough to start creating those problems, or until your store gets so busy that ot severely taxes webcat's ability to keep up with the traffic.I would tend to think that this data loss problem may have something to do with how much RAM is available for the webcat db's to reside in. If RAM is too limited then webcat has to perform repetitive db swaps into and out of memory. If this is happening a lot, especially on a busy site, it seems like there would be a much higher chance for data corruption (since there's far more writing of data to disk) than on a site that never has to swap db's into and out of RAM ...Sincerely,Kenneth Grome---------------------------------------------------WebDNA Professional Training and Development Center175 J. Llorente Street +63 (32) 255-6921Cebu City, Cebu 6000 kengrome@webdna.netPhilippines http://www.webdna.net----------------------------------------------------------------------------------------------------------------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/
Kenneth Grome
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:
WebCat2 - Getting to the browser's username/password data (1997)
form data submission get (1997)
MacFinder -- a new WebDNA web site (1998)
Calculating multiple shipping... (1997)
More on the email templates (1997)
downloading binary files ussing mime and tcpconnect (2004)
Where is eudora plugin? (1998)
[WriteFile] problems (1997)
WebCat B13 Mac CGI -- Frames question (1997)
Shopping problems with 2.1b3 acgi (1997)
Sample Tearoom Search Error (1998)
[group] ? (1997)
delete fails (2000)
F3 crashing server (1997)
WebCat2 - [format thousands] (1997)
Type 11 errors setting up WebCAt 2 (1997)
Unique value creation (1999)
japanese characters (1997)
Count how many items in a summ total (2003)
Narrowing NT Crashing error (2000)