Re: [WebDNA] Re: Hard-coded db write delay when running certain code?
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106228
interpreted = N
texte = --Boundary-01=_gXwRNlhi2tWsOaXContent-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: 7bit> > but once again I will remind you that flushing to disk> > has nothing to do with append times!> > yes, it has: with option "Automatically commit databases> to disk after modification", the [append] tags will be> processed one at a time, and if your db is something> like 500MB and your disk writes at 100MB/s, then it will> take *at least* 5 seconds to write.What I meant was that the timestamp will be recorded in the RAM copy of the db at the exact time when WebDNA interprets the append context, not later when that data is eventually flushed to disk.Newly appended records may not yet appear in the disk copy when you open that file in a text editor, but those new records -- with the correct append times -- still exist in the RAM copy. So unless I'm missing something I think I have to stick with my original claim that flushing to disk has no effect on append times. Sincerely,Kenneth Grome--Boundary-01=_gXwRNlhi2tWsOaXContent-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: 7bit
> > but once again I will remind you that flushing to disk
> > has nothing to do with append times!
>
> yes, it has: with option "Automatically commit databases
> to disk after modification", the [append] tags will be
> processed one at a time, and if your db is something
> like 500MB and your disk writes at 100MB/s, then it will
> take *at least* 5 seconds to write.
What I meant was that the timestamp will be recorded in the RAM copy of the db at the exact time when WebDNA interprets the append context, not later when that data is eventually flushed to disk.
Newly appended records may not yet appear in the disk copy when you open that file in a text editor, but those new records -- with the correct append times -- still exist in the RAM copy.
So unless I'm missing something I think I have to stick with my original claim that flushing to disk has no effect on append times.
Sincerely,
Kenneth Grome
--Boundary-01=_gXwRNlhi2tWsOaX--
Associated Messages, from the most recent to the oldest:
--Boundary-01=_gXwRNlhi2tWsOaXContent-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: 7bit> > but once again I will remind you that flushing to disk> > has nothing to do with append times!> > yes, it has: with option "Automatically commit databases> to disk after modification", the
[append] tags will be> processed one at a time, and if your db is something> like 500MB and your disk writes at 100MB/s, then it will> take *at least* 5 seconds to write.What I meant was that the timestamp will be recorded in the RAM copy of the db at the exact time when WebDNA interprets the append context, not later when that data is eventually flushed to disk.Newly appended records may not yet appear in the disk copy when you open that file in a text editor, but those new records -- with the correct append times -- still exist in the RAM copy. So unless I'm missing something I think I have to stick with my original claim that flushing to disk has no effect on append times. Sincerely,Kenneth Grome--Boundary-01=_gXwRNlhi2tWsOaXContent-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: 7bit
> > but once again I will remind you that flushing to disk
> > has nothing to do with append times!
>
> yes, it has: with option "Automatically commit databases
> to disk after modification", the [append] tags will be
> processed one at a time, and if your db is something
> like 500MB and your disk writes at 100MB/s, then it will
> take *at least* 5 seconds to write.
What I meant was that the timestamp will be recorded in the RAM copy of the db at the exact time when WebDNA interprets the append context, not later when that data is eventually flushed to disk.
Newly appended records may not yet appear in the disk copy when you open that file in a text editor, but those new records -- with the correct append times -- still exist in the RAM copy.
So unless I'm missing something I think I have to stick with my original claim that flushing to disk has no effect on append times.
Sincerely,
Kenneth Grome
--Boundary-01=_gXwRNlhi2tWsOaX--
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:
webcat/webmerchant docs (1997)
Applescript error (1998)
New NT beta available (1997)
OT- AS/400 and Macs (2003)
Friendly , quick 'security' check, please (2003)
Group Updates (1998)
[OT] For Mac Users (1999)
A Suggestion? (1998)
[WebDNA] [BULK] WebDNA Windows Install (2016)
[WriteFile] problems (1997)
I give up!! (1997)
OT - quiet on the list today - here's something (2004)
WebCat2 - Getting to the browser's username/password data (1997)
[WebDNA] [lookup] fails when using [url] to wrap a value for potential "&" char? (2009)
problems with 2 tags (1997)
WebCat2 several catalogs? (1997)
Implementing Gift Certificates in online store (1998)
Constructive criticism (2000)
Adding multiple items to Cart (1999)
Problem (1997)