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:

WebCatalog Upgrade Pricing? (1997) PCS Frames-Default page is solution! (1997) Checking Out! (1999) WebCat2: Formulas.db question (1997) text size limitation (1997) RE: creating writefile data from a nested search (1997) Announce: Bug fix talk list (1999) WebCommerce: Folder organization ? (1997) emailer (1997) Redirect and Window Size (2000) WC2b15 File Corruption (1997) WebCat NT v. Mac (1997) Unusual characters in the db ... (2002) shipcost (1997) RE: [WebDNA] [sendmail] attachment on unix (2014) carriage returns in data (1997) ShipCosts database (1997) WebCat2 - [format thousands] (1997) PCS Frames (1997) plus sign giving me problems in convertchars (2005)