Re: Updating a database once per day - An example
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17994
interpreted = N
texte = >I've been following this thread for a while now and I like Ken's technique>for handling the data swap - I only have one concern. What happens if your>[deletefile] calls out a db that has recently been closed by WebCat because>of a RAM limit?It still deletes the file, and that's all that matters.>Are you taking steps to make sure the file IS in RAM before>you delete the disk-based copy?No, because it doesn't have to be in RAM beforehand.The critical point is simply to make sure that from the instant it is purged from the RAM cache, it *stays purged* -- until WebCat has moved the new db file into position. The [delete] simply gets rid of the file on disk, so there's no chance of it being reloaded into RAM again ... until AFTER the new file is in position ... :)Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>I've been following this thread for a while now and I like Ken's technique>for handling the data swap - I only have one concern. What happens if your>
[deletefile] calls out a db that has recently been closed by WebCat because>of a RAM limit?It still deletes the file, and that's all that matters.>Are you taking steps to make sure the file IS in RAM before>you delete the disk-based copy?No, because it doesn't have to be in RAM beforehand.The critical point is simply to make sure that from the instant it is purged from the RAM cache, it *stays purged* -- until WebCat has moved the new db file into position. The
[delete] simply gets rid of the file on disk, so there's no chance of it being reloaded into RAM again ... until AFTER the new file is in position ... :)Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
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:
WebTen and WebCat (1997)
is 'template' a reserved webcat tag? (2000)
Plugin or CGI or both (1997)
pop up menu's (1998)
Emailer (1997)
ftp access on Macos X (2000)
Note added to [sendmail] in Docs (2004)
Interfacing WebMerchant to www.fedex.com (1997)
WebCatalog2 for NT Beta Request (1997)
StoreBuilder Shopping Cart (2000)
Location of Browser Info.txt file (1997)
credit card (1997)
Warning Message? (2000)
ExclusiveLock (2003)
Rank=off, reverse direction (2004)
RE:It just Does't add up!!! (1997)
Pithy questions on webcommerce & siteedit (1997)
date format (another question) (2000)
WebCat2 Append problem (B14Macacgi) (1997)
RE:It just Does't add up!!! (1997)