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:
4.5.1 on Panther? (2004)
Bug Report, maybe (1997)
[WebDNA] Speed up XML parsing (2010)
Simple Database close connection (2001)
WebCatalog NT beta 18 problem (1997)
Testing (2003)
Search or Lookup before Append (1998)
emailer on Windows Beta 18 (1997)
Upgrading old WebCat Database Files (1997)
WebCatalog f2 Installation (1997)
Processing all html files through WebCat or Typhoon (1998)
where to put code (1998)
Trying to loop for letters (1999)
Upload to LINUX always breaks my sites - why? (2004)
Word wrapping (1997)
WebCat2b15MacPlugin - [protect] (1997)
Search in 2 or more catalogs (1997)
MacAuthorize order data fields WAS:How To question... (1997)
World Address Info (2003)
locking variables? (2000)