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=_gXwRNlhi2tWsOaX Content-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=_gXwRNlhi2tWsOaX Content-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:

    
  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=_gXwRNlhi2tWsOaX Content-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=_gXwRNlhi2tWsOaX Content-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:

Error: Too many nested [xxx] contexts (WebTen only) (1997) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) WebCat2: Items xx to xx shown, etc. (1997) two domains and one cart and database (2000) WebCat2 - Getting to the browser's username/password data (1997) WebCatalog Hosting (1996) Summing fields (1997) WebCat2b13MacPlugIn - syntax to convert date (1997) Testing the WebCat Email List Members (2000) Multiple Pulldowns/Gary (1997) RE: type 2 errors with ssl server (1997) WebCat for Site Search? (1997) RE: protect tag on NT (1997) RE: Can WebCatalog.debug solve my problem? (2000) frames & carts (1997) email address with spaces (2001) t or f (1997) Credit card number for testing (2003) AOL and [referrer] (2001) Getting Total Quantity (1997)