Re: Database Not Found Problem
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55840
interpreted = N
texte = Justin Carroll wrote: > The engine basically pull the correct banner and then updates that banners > page views variable. Let me know your thoughts. Thanks. Instead of trying to do an inplace update to a single database, have the individual instances append a timestamp to a second database, then set up a trigger which runs every so often which summarizes the hits. The trigger can then update the banner's hit database (so you can make sure you spread the load around), but it will lag very slightly behind actual usage (but it will be much more robust). The update will never be in contention with the timestamp logging, so you shouldn't have any issues. The trigger should also clear the logging database when it is done with the summary. Additionally, if you are calling the same banner code from two independent frames on a page, you could unintentionally show the same banner twice. Better to use a single search term and return two records (you will know they are unique then). HTH John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- 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:
Justin Carroll wrote: > The engine basically pull the correct banner and then updates that banners > page views variable. Let me know your thoughts. Thanks. Instead of trying to do an inplace update to a single database, have the individual instances append a timestamp to a second database, then set up a trigger which runs every so often which summarizes the hits. The trigger can then update the banner's hit database (so you can make sure you spread the load around), but it will lag very slightly behind actual usage (but it will be much more robust). The update will never be in contention with the timestamp logging, so you shouldn't have any issues. The trigger should also clear the logging database when it is done with the summary. Additionally, if you are calling the same banner code from two independent frames on a page, you could unintentionally show the same banner twice. Better to use a single search term and return two records (you will know they are unique then). HTH John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- 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/
John Peacock
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:
WebCatalog for Postcards ? (1997)
shipcost (1997)
textarea to page display (1998)
WebCatalog for guestbook ? (1997)
[date format] w/in sendmail (1997)
How to combine two or more audio format files listed in a WebCat (1999)
Members register & gain access system (1998)
X etc.... (1999)
[BoldWords] WebCat.acgib15Mac (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Comments Please ... Omnis Studio v WC (2001)
[WebDNA] a major shift in strategy? (2008)
[WebDNA] mod_deflate and webdna (2017)
Server crash (1997)
Summing fields (1997)
writefile and deletefile (1998)
Stupid question (2003)
Next X hits (1996)
[SHOWNEXT] Examples (1997)
File Upload (1997)