Re: Closing Databases
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16566
interpreted = N
texte = >Do we first need to close the database, then quickly move the new file>in?Yes.>What happens if the database is queried at the same time? Is data>being lost?NO, becaseu queries don't even deal with the files on disk, they deal with the cached version of that data which is in RAM.Bit if a query causes WebCat to reload the old data into RAM again, before you've replaced it with the new file, then your new data will be overwritten the next time a [commitdatabase] or [closedatabase] or [flushdatabases] is encountered.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>Do we first need to close the database, then quickly move the new file>in?Yes.>What happens if the database is queried at the same time? Is data>being lost?NO, becaseu queries don't even deal with the files on disk, they deal with the cached version of that data which is in RAM.Bit if a query causes WebCat to reload the old data into RAM again, before you've replaced it with the new file, then your new data will be overwritten the next time a
[commitdatabase] or
[closedatabase] or
[flushdatabases] is encountered.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:
Grep help needed (2004)
math with multiple [founditems] (1999)
Tax Rate (2000)
WebCatalog NT (1996)
HTTP Header / Meta Equiv (1999)
Directory Overload (1998)
[WebDNA] Webdna and CMS (2012)
Email Attachments (1998)
WebCat2.0 [format thousands .0f] no go (1997)
Problems adding stuff to the shopping cart. (1997)
Sorting by date (1997)
Yet another db manager (2004)
RE: [WebDNA] directory protection questions (2008)
Conveting Characters to Graphics (1997)
WebCatalog on SUSE-Linux 6.3... please help! (2000)
sorting and grouping (1998)
[WebDNA] character encodings in linux (2011)
Secure server question (1997)
Editor (2000)
More on the email templates (1997)