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 Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: Updating a database once per day - An example ( 1998)
  2. Re: Updating a database once per day - An example (bob 1998)
  3. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  4. Re: Updating a database once per day - An example (Steve Rosenbaum 1998)
  5. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  6. Re: Updating a database once per day - An example (Marty Schmid 1998)
  7. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  8. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  9. Re: Updating a database once per day - An example (Gary Richter 1998)
  10. Re: Updating a database once per day - An example (Peter Ostry 1998)
  11. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  12. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  13. Re: Updating a database once per day - An example (Rob Marquardt 1998)
  14. Re: Updating a database once per day - An example (Peter Ostry 1998)
  15. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  16. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  17. Re: Updating a database once per day - An example (Rob Marquardt 1998)
  18. Re: Updating a database once per day - An example (Rob Marquardt 1998)
  19. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  20. Re: Updating a database once per day - An example (Steve Rosenbaum 1998)
  21. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  22. Updating a database once per day - An example (Steve Rosenbaum 1998)
>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 Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://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)