Re: 'page impression' techniques for banner ads
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22200
interpreted = N
texte = 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?Aloha, Olin -----Original Message----- From: PCS Technical Support
To: WebDNA-Talk@smithmicro.com Date: Saturday, January 02, 1999 8:47 AM Subject: Re: 'page impression' techniques for banner ads >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:
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?Aloha, Olin -----Original Message----- From: PCS Technical Support To: WebDNA-Talk@smithmicro.com Date: Saturday, January 02, 1999 8:47 AM Subject: Re: 'page impression' techniques for banner ads >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/ >
olin
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:
Another bug to squash (WebCat2b13 Mac .acgi) (1997)
using showpage and showcart commands (1996)
Possible Bug in 2.0b15.acgi (1997)
Stop the madness. (1997)
Requiring that certain fields be completed (1997)
[WebDNA] Installation problem (Debian 6 64bit + Lighttpd) (2011)
URL problem (2007)
dates and hex formatting (1997)
[ConvertChars] problem (1997)
[showif] results returned... (2003)
WebCat2 - many [carts] on one template page? (1997)
Re(5): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998)
WebCat2b12 - nesting [tags] (1997)
[/application] error? (1997)
case sensitivity in lookups (1997)
Formatting a .txt file (1998)
No Wanna Duppys (1998)
WebCatalog for guestbook ? (1997)
Carrying Forward (1998)
GuestBook example (1997)