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:
User that WebCatalog/Unix runs as (2000)
Re:Emailer setup (1997)
Help getting [shownext] to increment (2003)
New York City sales tax database needed (1997)
my price won't move (1997)
Protect Tage and Groups (1998)
Where is f2? (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
unable to launch acgi in WebCat (1997)
Who is doing sign-ups-got it (1998)
For those of you not on the WebCatalog Beta... (1997)
RE:It just Does't add up!!! (1997)
sort problems....bug or brain fart? (1997)
Weird Problem (1997)
WCS Newbie question (1997)
[WebDNA] [sendmail] mystery (2009)
What are SMSI's upgrade policies? (2003)
Anyone have a register your domain app? (2000)
[SHOWIF] (1997)
Associative lookup style? + bit more (1997)