Re: Database Not Found Problem
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55841
interpreted = N
texte = I completely understand what you're saying and I see how it would work; = however, I'm bothered by jumping through hoops to such a simple task done. = Shouldn't WebCatalog have a built in waitforfile type function for = accessing the same db at the same time? Are there any other suggestions out there? Thanks. Justin Carroll On Tuesday, March 23, 1943, John Peacock
wrote: >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=20 >individual instances append a timestamp to a second database, then set up = a=20 >trigger which runs every so often which summarizes the hits. The trigger = can=20 >then update the banner's hit database (so you can make sure you spread = the load=20 >around), but it will lag very slightly behind actual usage (but it will = be much=20 >more robust). The update will never be in contention with the timestamp=20 >logging, so you shouldn't have any issues. The trigger should also clear = the=20 >logging database when it is done with the summary. > >Additionally, if you are calling the same banner code from two = independent=20 >frames on a page, you could unintentionally show the same banner twice. = Better=20 >to use a single search term and return two records (you will know they are= =20 >unique then). > >HTH > >John > >--=20 >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/ > ------------------------------------------------------------- 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:
I completely understand what you're saying and I see how it would work; = however, I'm bothered by jumping through hoops to such a simple task done. = Shouldn't WebCatalog have a built in waitforfile type function for = accessing the same db at the same time? Are there any other suggestions out there? Thanks. Justin Carroll On Tuesday, March 23, 1943, John Peacock wrote: >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=20 >individual instances append a timestamp to a second database, then set up = a=20 >trigger which runs every so often which summarizes the hits. The trigger = can=20 >then update the banner's hit database (so you can make sure you spread = the load=20 >around), but it will lag very slightly behind actual usage (but it will = be much=20 >more robust). The update will never be in contention with the timestamp=20 >logging, so you shouldn't have any issues. The trigger should also clear = the=20 >logging database when it is done with the summary. > >Additionally, if you are calling the same banner code from two = independent=20 >frames on a page, you could unintentionally show the same banner twice. = Better=20 >to use a single search term and return two records (you will know they are= =20 >unique then). > >HTH > >John > >--=20 >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/ > ------------------------------------------------------------- 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/
Justin Carroll
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:
WebDNA-Talk Digest mode broken (1997)
Server crash (1997)
Web requests in que... (2007)
[WebDNA] Serious sendmail problems in 8.02 and 8.1 (2015)
Just a thought (1998)
multi-paragraph fields (1997)
WebDNA tags in WebMerchant email templates ... (1997)
UPS charges (2000)
Multiple prices (1997)
Re:Merging databases (1997)
$Replace with [founditems] (1997)
stumped (2001)
Just made store and move file from webcatalog......... (2000)
Almost a there but..bye bye NetCloak (1997)
Different Drive (2003)
This may make you do a double take (2004)
No luck with taxes (1997)
Checkboxes (1998)
Re:no template caching (1997)
Running 2 two WebCatalog.acgi's (1996)