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:
page redirect in webDNA (1997)
process SSI (1998)
Multiple Newcarts (1996)
Image maps/Webcat (1997)
[searchString] (1997)
[WebDNA] OT: FCKeditor (2008)
Problem with broken images (2004)
Order not created error (1997)
[WebDNA] FW: Weird non-interpretation of some templates since move to MacTel version (2009)
Use WebCat to search files in a folder like a search engine? (2001)
PCS Frames (1997)
BBedit glossary for WebCat? (2000)
PIXO support (1997)
Mac Vs WindowsNT (1997)
[WebDNA] Escaping content for JSON (2016)
simple [convertChars] Q (2000)
The code, one more time. (2003)
ShoppingCart Woes (1998)
Dates (1998)
Changes to the List (1997)