Page Views Database
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59584
interpreted = N
texte = Hi Everyone, I'm developing an advertising system that will record click throughs and page views, and I need to get some feedback on the limitations of databases with WebDNA. I'm currently running webdna 5 and Webstar on OSX. I'm not too worried about a table recording click throughs since it should stay relatively small. But if I set up an append context to record a page view every time a page gets accessed/refreshed, will I get into performance issues with the page loading or with people accessing other webDNA pages? We get over a million hits a month, so I'm looking at at least a million records a month in a page views table. Will I have to set up some scripts to flush out the page views table regularly or can I just let it continue to get bigger and bigger? Or should I not try to use webDNA at all for this, and instead find a way to use the server log file? Thanks in advance to anyone who has time to respond. Allen Frye Zambooie http://www.zambooie.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi Everyone, I'm developing an advertising system that will record click throughs and page views, and I need to get some feedback on the limitations of databases with WebDNA. I'm currently running webdna 5 and Webstar on OSX. I'm not too worried about a table recording click throughs since it should stay relatively small. But if I set up an append context to record a page view every time a page gets accessed/refreshed, will I get into performance issues with the page loading or with people accessing other webDNA pages? We get over a million hits a month, so I'm looking at at least a million records a month in a page views table. Will I have to set up some scripts to flush out the page views table regularly or can I just let it continue to get bigger and bigger? Or should I not try to use webDNA at all for this, and instead find a way to use the server log file? Thanks in advance to anyone who has time to respond. Allen Frye Zambooie http://www.zambooie.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Allen Frye"
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:
WebCat2: Items xx to xx shown, etc. (1997)
[OT] HTML EMAIL program wanted (1999)
remotely add + sign (1997)
It's working (1997)
[format] problems (2000)
Search for starts with and ends with? (2003)
Showif, Hideif reverse logic ? (1997)
MasterCounter and capitalization (1997)
WebCat2 - storing unformatted date data? (1997)
SHOWIF/HIDEIF empty fields (2005)
UPS uber integration (2007)
Verifying both name and password (was: New Problem) (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
WebCatalog Upgrade Pricing? (1997)
Robots fill event log (1997)
Not reading code (1997)
AuthNet/TCPConnect Timeouts (2003)
[REFERRER] works with form posts (2003)
[WebDNA] TCPConnect w/ user:pass (2009)