Re: [WebDNA] To Commitdatabase or Not to Commitdatabase
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108440
interpreted = N
texte = We did a test that i published no so long ago: If you commit databases to disk after modification, it will entirely = depend on the size of your databases and the frequency you write it to = disk: a standard 7200rpm drive is usually able to write 70MB/s. So, if = you get one new [append] every second and your database is a 100MB one, = then you might expect serious I/O disk activity and probably some = latency. The speed difference with "Only commit databases to disk when = instructed" will be a huge one. If the database is 2MB only, the = difference will be smaller. We did some tests that i published not long ago: Automatically commit databases to disk after modification = --------------------------------------------------------------------------= ------- WebDNA 7.0.628 iMac 2.4GHz, 3GB RAM Open a database (2 fields), append 10000 records.......................: = 5 s Only commit databases to disk when instructed = --------------------------------------------------------------------------= ------- WebDNA 7.0.628 iMac 2.4GHz, 3GB RAM Open a database (2 fields), append 10000 records.......................: = 0 s Note that this does not measure one single database write, but rather = 10,000 successive writes - chris On Feb 2, 2012, at 16:48, Govinda wrote: >> The reason for my question above was to figure out if my next move = should be enabling
or just taking on the task of doing a = after (more or less) all of my [append] or [replace] tags. >>=20 >> If I was to gain speed / performance by choosing one over the other = then that is what I am looking for. >=20 > I don't know. Maybe someone (WSC?) has clocked the difference. =20 > You might able to make the speed tests yourself, if you wanted. > I am guessing it is the same internal mechanism, and so no speed = difference.. (assuming you put a [commitdatabase...] after *every* = write operation). >=20 > Personally, if I wanted to be sure every write operation resulted in = an updated disk copy, I would not bother any more more than just turning = on the auto-commit feature. >=20 > -G >=20 > --------------------------------------------------------- > 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
Associated Messages, from the most recent to the oldest:
We did a test that i published no so long ago: If you commit databases to disk after modification, it will entirely = depend on the size of your databases and the frequency you write it to = disk: a standard 7200rpm drive is usually able to write 70MB/s. So, if = you get one new [append] every second and your database is a 100MB one, = then you might expect serious I/O disk activity and probably some = latency. The speed difference with "Only commit databases to disk when = instructed" will be a huge one. If the database is 2MB only, the = difference will be smaller. We did some tests that i published not long ago: Automatically commit databases to disk after modification = --------------------------------------------------------------------------= ------- WebDNA 7.0.628 iMac 2.4GHz, 3GB RAM Open a database (2 fields), append 10000 records.......................: = 5 s Only commit databases to disk when instructed = --------------------------------------------------------------------------= ------- WebDNA 7.0.628 iMac 2.4GHz, 3GB RAM Open a database (2 fields), append 10000 records.......................: = 0 s Note that this does not measure one single database write, but rather = 10,000 successive writes - chris On Feb 2, 2012, at 16:48, Govinda wrote: >> The reason for my question above was to figure out if my next move = should be enabling or just taking on the task of doing a = after (more or less) all of my [append] or [replace] tags. >>=20 >> If I was to gain speed / performance by choosing one over the other = then that is what I am looking for. >=20 > I don't know. Maybe someone (WSC?) has clocked the difference. =20 > You might able to make the speed tests yourself, if you wanted. > I am guessing it is the same internal mechanism, and so no speed = difference.. (assuming you put a [commitdatabase...] after *every* = write operation). >=20 > Personally, if I wanted to be sure every write operation resulted in = an updated disk copy, I would not bother any more more than just turning = on the auto-commit feature. >=20 > -G >=20 > --------------------------------------------------------- > 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
christophe.billiottet@webdna.us
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:
password authentication schemes (2003)
blank fields (1999)
[append] vs. [appendfile] delta + question? (1997)
wo search help (1999)
Files not moved to EmailCompleted (2002)
username = 115 (1999)
Forms Search Questions (1997)
Sort Order on a page search (1997)
Embedded [Search] Context Snippets (Very Useful) (1998)
PHP vs WebCatalog (2000)
state? (2004)
Exclamation point (1997)
WebCatb15 Mac CGI -- [purchase] (1997)
WebCatalog for Postcards ? (1997)
Gremlins, huh? (2000)
Running _every_ page through WebCat ? (1997)
Trigger action Quandry (2002)
New public beta available (1997)
Using Applescript to process WebCatalog functions (1998)
Nested vs conditional (1997)