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:

Shopping carts and reloading pages (1997) Area codes? (2001) Limits (2000) missing records (1998) Upgrade on MacOSX 3.05 to 3.08 (2000) [OT] Theiving B*****ds (2004) CMS (2003) RE: How much ram??? (1997) Weird cart problem (webcat 2.x) (2000) Shopping Cart Problem (1998) Generating unique SKU from [cart] - Still Stumped... (1997) Newbie: ASIP vs WebTen? (2000) [WebDNA] contents of db files disappearing including triggers.db (2019) Separate SSL Server (1997) Cart -> Date and Time (2004) Network Drives (2005) text size limitation (1997) Paypal merchant code tricks or pitfalls (2003) [WebDNA] Different results for [THISURL] (2018) OSX SubAdmin Templates (2000)