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:

Sort Order on a page search (1997) Hyperboard users wanting a quoted message (1998) WebMerchant when CC network is down (1998) Unix Timestamp using WebDNA [code req] (2003) HELP WITH DATES (1997) authenticate (1999) What does this error mean? (2000) WebCatalog and WebMerchant reviewed by InfoWorld (1997) Multiple edits/replacementsd to db. Possible? (1997) linetiems in thankyou.tpl (1997) PIXO (1997) webstar (ot) (2001) 4.0 send email ticks. . (2000) [OT] SSL (2003) #$%@! formulas (1998) UPS Online help (2003) Roundup function? (1997) WebCat2b13MacPlugIn - more [date] problems (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) OT - Need A Good Address Parser (2000)