Re: 'page impression' techniques for banner ads
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22217
interpreted = N
texte = I once (with WebCat 2.x) tried doing replaces inside a HUGE database file (>100 Meg RAM). Even with autocommit off, it occasionally flushed the whole .db to disk. This made approach #1 unreasonable. Perhaps it is OK with much smaller .db's where the occasional flush to disk is not noticeable. At the time, PCS confirmed that replaces do occasionally get flushed to disk even with autocommit off. I believe they said around every 100 operations or so.Has this changed?I went with appending a separate database instead. But I'm curious how the speed of appending a database varies with size of the .db. If I let this log file grow, will there be a speed hit as it continues to append the file?ThanksSandy>Yes, I think your ordering is correct, and you may even be able to speed up >the replace a little with case-sensitivity turned on. Replace operates >entirely RAM-based as often as possible. > >>#1 would be fastest because it uses a database to calculate and store the >>total page impressions. If replacing a database field value is always >>faster than writing that value to a separate text file, this would seem to >>be the fastest solution -- because it does not require a disk hit. >> >>#2 would be second-fastest because all it does is append a single >>character to the end of a separate text file -- no additional [include]s, >>and no [math] to perform ... >> >>#3 would be slowest because it must include the value of a separate text >>file, then perform a math calculations on that value, then re-write the >>results to the separate text file. > >Technical Support | ==== eCommerce and Beyond ==== >Pacific Coast Software | WebCatalog, WebMerchant, >11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, >San Diego, CA 92128 | Typhoon >619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ > >
Associated Messages, from the most recent to the oldest:
I once (with WebCat 2.x) tried doing replaces inside a HUGE database file (>100 Meg RAM). Even with autocommit off, it occasionally flushed the whole .db to disk. This made approach #1 unreasonable. Perhaps it is OK with much smaller .db's where the occasional flush to disk is not noticeable. At the time, PCS confirmed that replaces do occasionally get flushed to disk even with autocommit off. I believe they said around every 100 operations or so.Has this changed?I went with appending a separate database instead. But I'm curious how the speed of appending a database varies with size of the .db. If I let this log file grow, will there be a speed hit as it continues to append the file?ThanksSandy>Yes, I think your ordering is correct, and you may even be able to speed up >the replace a little with case-sensitivity turned on. Replace operates >entirely RAM-based as often as possible. > >>#1 would be fastest because it uses a database to calculate and store the >>total page impressions. If replacing a database field value is always >>faster than writing that value to a separate text file, this would seem to >>be the fastest solution -- because it does not require a disk hit. >> >>#2 would be second-fastest because all it does is append a single >>character to the end of a separate text file -- no additional
[include]s, >>and no
[math] to perform ... >> >>#3 would be slowest because it must include the value of a separate text >>file, then perform a math calculations on that value, then re-write the >>results to the separate text file. > >Technical Support | ==== eCommerce and Beyond ==== >Pacific Coast Software | WebCatalog, WebMerchant, >11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, >San Diego, CA 92128 | Typhoon >619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ > >
Sandra L. Pitner
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:
RE: Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997)
Web Catalog 2 demo (1997)
[WebDNA] Fails from http:// but works from file:/// (2009)
[WebDNA] writing pdfs on the fly (Avery labels #5160) (2010)
Web Logs (1998)
NumFound (1999)
Aquick question about replace (1999)
OT: need bad code (2005)
Plugin or CGI or both (1997)
Variable Math (1998)
Re1000001: Setting up shop (1997)
copyfile (2003)
[TaxableTotal] - not working with AOL and IE (1997)
DreamWeaver Extensions for Mac (2000)
[Reload mydata.db] (1998)
HTTP upload (2000)
search form problem.. (1997)
Mac app. that converts e-mails (2000)
calculating tax rates, mail order solutions and version 2 (1997)
UPS Online help (2003)