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 = 106231
interpreted = N
texte = --Boundary-01=_nrwRNSAxXnKBmQx Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit No problem, thanks Chris! Sincerely, Kenneth Grome > ok, i thought you were mentionning the timestamp for the > database file itself, not the one associated with the > recorded [append]. > > On Jan 31, 2011, at 16:56, Kenneth Grome wrote: > > > > 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 > > ------------------------------------------------------- > > -- This message is sent to you because you are > > subscribed to the mailing list . To unsubscribe, > > E-mail to: archives: > > http://mail.webdna.us/list/talk@webdna.us Bug > > Reporting:support@webdna.us > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us --Boundary-01=_nrwRNSAxXnKBmQx Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit

No problem, thanks Chris!

Sincerely,

Kenneth Grome

> ok, i thought you were mentionning the timestamp for the

> database file itself, not the one associated with the

> recorded [append].

>

> On Jan 31, 2011, at 16:56, Kenneth Grome wrote:

> > > > 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

> > -------------------------------------------------------

> > -- This message is sent to you because you are

> > subscribed to the mailing list . To unsubscribe,

> > E-mail to: archives:

> > http://mail.webdna.us/list/talk@webdna.us Bug

> > Reporting:support@webdna.us

>

> ---------------------------------------------------------

> This message is sent to you because you are subscribed to

> the mailing list <talk@webdna.us>.

> To unsubscribe, E-mail to: <talk-leave@webdna.us>

> archives: http://mail.webdna.us/list/talk@webdna.us

> Bug Reporting: support@webdna.us

--Boundary-01=_nrwRNSAxXnKBmQx-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Hard-coded db write delay when running certain code? (christophe.billiottet@webdna.us 2011)
  2. [WebDNA] Hard-coded db write delay when running certain code? (Kenneth Grome 2011)
--Boundary-01=_nrwRNSAxXnKBmQx Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit No problem, thanks Chris! Sincerely, Kenneth Grome > ok, i thought you were mentionning the timestamp for the > database file itself, not the one associated with the > recorded [append]. > > On Jan 31, 2011, at 16:56, Kenneth Grome wrote: > > > > 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 > > ------------------------------------------------------- > > -- This message is sent to you because you are > > subscribed to the mailing list . To unsubscribe, > > E-mail to: archives: > > http://mail.webdna.us/list/talk@webdna.us Bug > > Reporting:support@webdna.us > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us --Boundary-01=_nrwRNSAxXnKBmQx Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit

No problem, thanks Chris!

Sincerely,

Kenneth Grome

> ok, i thought you were mentionning the timestamp for the

> database file itself, not the one associated with the

> recorded [append].

>

> On Jan 31, 2011, at 16:56, Kenneth Grome wrote:

> > > > 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

> > -------------------------------------------------------

> > -- This message is sent to you because you are

> > subscribed to the mailing list . To unsubscribe,

> > E-mail to: archives:

> > http://mail.webdna.us/list/talk@webdna.us Bug

> > Reporting:support@webdna.us

>

> ---------------------------------------------------------

> This message is sent to you because you are subscribed to

> the mailing list <talk@webdna.us>.

> To unsubscribe, E-mail to: <talk-leave@webdna.us>

> archives: http://mail.webdna.us/list/talk@webdna.us

> Bug Reporting: support@webdna.us

--Boundary-01=_nrwRNSAxXnKBmQx-- 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:

[WebDNA] bring back PORT feature! (2017) Limiting user access to .tmpl files (1997) [WebDNA] [listfiles] error, but why? How to turn off (2010) Who is doing sign-ups-got it (1998) Re:[ShowIf] and empty fields (1997) Frames and WebCat (1997) Date search - yes or no (1997) Saving Text Areas with Orders (1997) [WriteFile] problems (1997) [format 40s]text[/format] doesn't work (1997) Replacing a Word (1999) WebCat2 several catalogs? (1997) Summing fields (1997) Blowback and budgets. (2000) Followup question re: checksum for credit cards? (1997) [WebDNA] (2010) Multi Math bug? (2000) WebMerchant Mac 3.0 beta available (1998) New commands in Final candidate (1997) Re:Emailer tracking (1997)