Re: Updating a database once per day - An example

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17997
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 ... :) >Wait! Since I started this thread & I articulated two assumptions for this scenario:#1the new database file is in position (with the same file name in the same folder) before the closedatabase command gets issued.#2 the database contents get updated manually, they never gets updated through WebCatalog - thus, when one issues the [CLOSEDATABASE my.db] command, no changes get written to disk because WebCatalog does not think there any changes.My testing leads me believe that one does not need to move and delete and copy files if one sticks with the above two assumptions, but Ken seems to disagree. I think a ruling by PCS is needed.Steve Rosenbaum steve@pop-art.com 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 ... :) >Wait! Since I started this thread & I articulated two assumptions for this scenario:#1the new database file is in position (with the same file name in the same folder) before the closedatabase command gets issued.#2 the database contents get updated manually, they never gets updated through WebCatalog - thus, when one issues the [CLOSEDATABASE my.db] command, no changes get written to disk because WebCatalog does not think there any changes.My testing leads me believe that one does not need to move and delete and copy files if one sticks with the above two assumptions, but Ken seems to disagree. I think a ruling by PCS is needed.Steve Rosenbaum steve@pop-art.com Steve Rosenbaum

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:

Request for page test (2003) F3 crashing server (1997) redirect from the errorsMessages.db entry (1997) Another bug to squash (WebCat2b13 Mac .acgi) (1997) WebDNA 4.5 not starting on boot? (2002) Quicky Date thing (2005) many-to-one problem (1998) [WebDNA] WebDNA Hosting (2008) Sku numbers (1997) Re:Help name our technology! (1997) Join us at MacWorld! (1998) WCS Newbie question (1997) WebCatalog2 Feature Feedback (1996) setlineiems and UnitShip Cost (2000) Errata: WCS Newbie question (1997) Shopping Cart Problem (1998) Using Plug-In while running 1.6.1 (1997) [WebDNA] search command problem (2009) Webstar SSL and Non-SSL question (1998) EIMS Problems (1997)