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:
multiple product databases (1997)
If Empty ? (1997)
[quantity] within formulas (1997)
Running 2 two WebCatalog.acgi's (1996)
Searching an Email database (1997)
virtual domain service (1997)
Shipcost Prob solved, new one arises (1998)
RE: 2.01 upgrade problems (1997)
Selected Item in Pop-down (2003)
Prevent multiple appends with Reload Button (1997)
[WebDNA] Web Hosting (2008)
off-topic: SMS interface? (2001)
All of a Sudden Type 2 errors (1999)
Out of the woodwork (2007)
& not allowed in db by definition? (1999)
problems with 2 tags (1997)
quantity minimum problem (1997)
Sum of [founditems] ? (2004)
two of the same named db's open at once (1998)
Forms & Tables (1998)