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:
More on the email templates (1997)
Getting the domain of every request ... (2003)
Notepad problems (1998)
Variable prices and Formulas.db (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Web Catalog 2 demo (1997)
required fields (1999)
[SHOWIF]s and empty arguments (1997)
Re2: AAgghh!! Help, please. SSL strikes again. (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Frames and WebCat (1997)
Formulas.db / Quantity Discount problem (1998)
[returnraw] and form variables (1998)
[BoldWords] WebCat.acgib15Mac (1997)
access denied problem (1997)
Shownext! (1998)
writing db to disk (1997)
Sequential Code Logic (2003)
WebCat2 - [format thousands] (1997)
html delivery (1997)