Re: 'page impression' techniques for banner ads
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22218
interpreted = N
texte = >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?No, this has not changed. But it's not every 100 operations, it's every 100 changes to the database that would cause some internal limits to grow, most noticeably [replace append=t]. It's complex, but the idea is we limit disk activity as much as possible for speed reasons.>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?If you use [Append] and treat it as a database, then it will still flush and reload around every 100 appends (we don't guarantee that it will always be that, but right now it is). If you use [AppendFile] so that it is not treated as a database, then size does not affect speed; it's always very fast.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:
>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?No, this has not changed. But it's not every 100 operations, it's every 100 changes to the database that would cause some internal limits to grow, most noticeably [replace append=t]. It's complex, but the idea is we limit disk activity as much as possible for speed reasons.>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?If you use
[append] and treat it as a database, then it will still flush and reload around every 100 appends (we don't guarantee that it will always be that, but right now it is). If you use
[appendfile] so that it is not treated as a database, then size does not affect speed; it's always very fast.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/
PCS Technical Support
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:
WC2.0 Memory Requirements (1997)
TEXTA-D (2003)
[BoldWords] WebCat.acgib15Mac (1997)
Problem with textA (2000)
SSL (1998)
back one? (2000)
Calculating Shipping charges for multiple items and qtys > 1 (1997)
WebDelivery downloads alias, not original ? (1997)
delete after x (1998)
[OT] Flash conternt only in IE? (2006)
Setting variables. (1998)
suffix mapping for NT? (1997)
Country & Ship-to address & other fields ? (1997)
Not really WebCat (1997)
Emailer and encryption (1997)
How to get shownext to just shownext once (1997)
Item counting? (1998)
[WebDNA] Date: header on emails - timezone problem perhaps (emai)
Resume Catalog ? (1997)
New Cart No. on same page (2003)