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:
Include a big block of text (1997)
SKU number. (2000)
[WebDNA] Search/sort/summ problem (2010)
Looking up two prices in database? (1997)
WebCatalog 2.0 b 15 mac (1997)
Poll security (2004)
Help name our technology! (1997)
problems with 2 tags (1997)
RequiredFields template (1997)
WC2b15 File Corruption (1997)
Bug? (1997)
2.0 Info (1997)
WebCatalog complains that the service is not running. (1998)
Alais Shopping Cart Directory (1998)
{Grouping} Docs (1999)
type 2 errors with ssl server (1997)
what's wrong with this picture (2006)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
[MATH] and Dates (1998)
[BoldWords] WebCat.acgib15Mac (1997)