Re: I've had it!

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23407
interpreted = N
texte = I just wanted to post a follow up about my post from last Saturday. Last week I was having considerable problems with my web server's stability. During this last week, I went through every site on the machine, and recoded portions of applicable websites to limit searching and lookups, bearing in mind that WebCatalog locks access to an entire database while it is doing a replace function. This has almost entirely eliminated my server speed problems. (Three of my sites do a search/replace with 2 or 3 lookups in the same database per page of the entire site. My speed issues would probably not affect many other shoppable sites.) This however, did not eliminate the server from locking up. (MacOS, WebStar3, WebCat CGI) I have finally nailed down the bug.In the most recent beta (and affecting earlier versions too) this code will cause the server to come to a complete stop: [SetHeader db=prod.db&cart=[cart]&index=1]header28=[browsername][/setheader] ***** IF the browsername is: ***** Mozilla/4.0 (compatible; MSIE 4.0; Windows 95; AT&T WNS IE4.0)My guess here is that the & (ampersand) is causing the problem.The workaround (of course) is: [SetHeader db=prod.db&cart=[cart]&index=1]header28=[url][browsername][/url] [/setheader]Although I realize the second way is the proper(?!?) way of doing it, I think that perhaps WebCatalog should be coded such as it wouldn't bomb(!) if it was simply put in as the top example.I am now looking for suggestions for ISPs that will do image collocation, approx 20-30Gig/month transfer. Needs to be a T3 based provider. Thanks! Brian B. Burton BOFH - Department of Redundancy Department --------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.comAre you a Web Programmer? I am today.> for the 25th time (literally!) today, web catalog ACGI for the mac has self > quit, launched itself again, and popped up a damn serial number protection > screen in front of my shoppers! on top of that, given heavy traffic (which is > supposed to be a good thing) a lousy replace function locks up the entire > database that tracks site preferences because WebCatalog doesn't seem to be able > to do record locking. > I've had over 7000 visitors today, but only 123 orders (given an average day > ratio, I should have had over 350 orders) mostly because this site slows to a > damn crawl under any real traffic. > This week, I'm installing an NT server. I give it a week, if it doesn't improve, > I declare Webcatalog completely incapable for medium to large sites, and I'm > gone. Associated Messages, from the most recent to the oldest:

    
  1. Re: I've had it! (Brian B. Burton 1999)
  2. Re:I've had it! (Larry Hewitt 1999)
  3. Re: I've had it! (Kenneth Grome 1999)
  4. Re:I've had it! (Jay Van Vark 1999)
  5. I've had it! (Brian B. Burton 1999)
I just wanted to post a follow up about my post from last Saturday. Last week I was having considerable problems with my web server's stability. During this last week, I went through every site on the machine, and recoded portions of applicable websites to limit searching and lookups, bearing in mind that WebCatalog locks access to an entire database while it is doing a replace function. This has almost entirely eliminated my server speed problems. (Three of my sites do a search/replace with 2 or 3 lookups in the same database per page of the entire site. My speed issues would probably not affect many other shoppable sites.) This however, did not eliminate the server from locking up. (MacOS, WebStar3, WebCat CGI) I have finally nailed down the bug.In the most recent beta (and affecting earlier versions too) this code will cause the server to come to a complete stop: [SetHeader db=prod.db&cart=[cart]&index=1]header28=[browsername][/setheader] ***** IF the browsername is: ***** Mozilla/4.0 (compatible; MSIE 4.0; Windows 95; AT&T WNS IE4.0)My guess here is that the & (ampersand) is causing the problem.The workaround (of course) is: [SetHeader db=prod.db&cart=[cart]&index=1]header28=[url][browsername][/url] [/setheader]Although I realize the second way is the proper(?!?) way of doing it, I think that perhaps WebCatalog should be coded such as it wouldn't bomb(!) if it was simply put in as the top example.I am now looking for suggestions for ISPs that will do image collocation, approx 20-30Gig/month transfer. Needs to be a T3 based provider. Thanks! Brian B. Burton BOFH - Department of Redundancy Department --------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.comAre you a Web Programmer? I am today.> for the 25th time (literally!) today, web catalog ACGI for the mac has self > quit, launched itself again, and popped up a damn serial number protection > screen in front of my shoppers! on top of that, given heavy traffic (which is > supposed to be a good thing) a lousy replace function locks up the entire > database that tracks site preferences because WebCatalog doesn't seem to be able > to do record locking. > I've had over 7000 visitors today, but only 123 orders (given an average day > ratio, I should have had over 350 orders) mostly because this site slows to a > damn crawl under any real traffic. > This week, I'm installing an NT server. I give it a week, if it doesn't improve, > I declare Webcatalog completely incapable for medium to large sites, and I'm > gone. Brian B. Burton

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:

WC2f3 (1997) problem: mail changed (1997) [WebDNA] Ubuntu 14 WebDNA FCGI suffix mapping for .html files (2020) Re:no [search] with NT (1997) Reversed words (1997) formulas.db (1999) How Many SKU's is enough? (1997) ShowNext (1997) RE: Shopping Cart Questions (1998) WCS Newbie question (1997) A better WebCat whois (was [OT] Domain Name Scam) (2000) Size limit for tmpl editor ? (1997) Keyword search (2004) can WC render sites out? (1997) authenticating a second user (1997) IE problems persist (2004) WebCatalog Hosting (1996) Solution help needed (1998) WebCat2 - storing unformatted date data? (1997) Faxing orders in place of email (1997)