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:
ThreadMem ignored? (1998)
The List is Changing (1997)
Re[2]: Re[2]: WebCatalog on Linux (2000)
Summing fields (1997)
Add to Cart & List of Products (1997)
WebCatalog + Linux + ODBC + Oracle ! ? (2000)
Re:quit command on NT (1997)
[WebDNA] I'm stuck... :-( (2009)
How to verify email address (1997)
Multiple cart additions (1997)
WebCat2: Found Items syntax, etc. (1997)
lookup and two records? (1997)
[movefile] (1999)
Moving files from one server to another... (2001)
Is this possible, WebCat2.0 and checkboxes (1997)
Webcat engine freezes when [tcpconnect] can't connect (2003)
Adding non-SKUs to cart (1998)
Re[2]: Next X hits (1996)
Re:PCS Customer submissions ? (1997)
Sorting by date (1997)