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:

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)