Re: 'page impression' techniques for banner ads
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22202
interpreted = N
texte = >Re: >>How does closedatabase and commit database affect speed? If a server crashes >>and use the #1 technique then I'll lose a lot of the data. So if I add a >>commitdatabase call would that be the same as going to the disk like option >>2? > >OK.... (or as Support 2 used to say, Ah ha.. gotcha) > >WHY can't the databases be automatically saved to disk and the ram freed >when a replace, append, write etc... contexts is (are) sent?In a sense, they can. In the WebCatalog admin area, turn on autocommit databases. This will save any modification to any database to disk immediately. Please note, you will pay a HEAVY speed penalty if you are doing operations like comparing one database to another and integrating record changes to synchronize the two. Perhaps a future version of webcatalog will allow you (in the admin area) to turn on autocommit for each database, or give us a command to temporarily turn off autocommit databases while an operation is taking place. [commitoff db=somedata.db]blah blah blah[commiton db=somedata.db]BTW, closedatabase will not lose any data, as it commits the ram to disk, then flushes the ram of the database. Commitdatabase only saves from ram to disk, but it leaves the database in ram afterward.Why close the whole database because you did a replace? All you need to do it write the database to disk (for safety) which commitdatabase will do. Brian B. Burton BOFH - Department of Redundancy Department --------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.comAre you a Web Programmer? I am today.
Associated Messages, from the most recent to the oldest:
>Re: >>How does closedatabase and commit database affect speed? If a server crashes >>and use the #1 technique then I'll lose a lot of the data. So if I add a >>commitdatabase call would that be the same as going to the disk like option >>2? > >OK.... (or as Support 2 used to say, Ah ha.. gotcha) > >WHY can't the databases be automatically saved to disk and the ram freed >when a replace, append, write etc... contexts is (are) sent?In a sense, they can. In the WebCatalog admin area, turn on autocommit databases. This will save any modification to any database to disk immediately. Please note, you will pay a HEAVY speed penalty if you are doing operations like comparing one database to another and integrating record changes to synchronize the two. Perhaps a future version of webcatalog will allow you (in the admin area) to turn on autocommit for each database, or give us a command to temporarily turn off autocommit databases while an operation is taking place. [commitoff db=somedata.db]blah blah blah[commiton db=somedata.db]BTW, closedatabase will not lose any data, as it commits the ram to disk, then flushes the ram of the database. Commitdatabase only saves from ram to disk, but it leaves the database in ram afterward.Why close the whole database because you did a replace? All you need to do it write the database to disk (for safety) which commitdatabase will do. Brian B. Burton BOFH - Department of Redundancy Department --------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.comAre you a Web Programmer? I am today.
Brian B. Burton
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:
Banner DNA (1997)
Macauth: Dates and No Scripting... (1997)
Setting user/password with a form. (2000)
Re:2nd WebCatalog2 Feature Request (1996)
Associative lookup style? + bit more (1997)
emailer w/F2 (1997)
SMSI: Forged email addresses on the talk list ... (2002)
Add to a filename in multifile upload (2002)
Checkboxes (1998)
Swear words (2002)
Re[2]: Enhancement Request for WebCatalog-NT (1996)
No. of items in shopping cart (2000)
[WebDNA] Test - no messages since 9th of June 2009. (2009)
WCS Newbie question (1997)
listfiles sort?! (2005)
[WebDNA] Store module/site (2012)
[format xs] freeze (1997)
Inventory / Catalog (2003)
Protect vs Authenicate (1997)
Re:UPS, FEDEX TRACKING (1999)