Re: Server slowing down.
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11023
interpreted = N
texte = >Does having the embedded search commands in pages have a slowdown effect on >the server? I have one page on our site that has about 7 to 8 searches >going on at: http://www.fishingworld.com/News/.Yes, it slows down at a linear rate based on how many records and how complex the search is. But that's to be expected. If you're getting some kind of exponential or sudden slowdown, I suspect you're on the edge of your RAMDoubler's ability to hold WebSTAR, WebCatalog, and all databases in RAM.Also, make sure your error log is cleared out. One of our sites had 30,000 errors in the log, and WebCatalog was 'thrashing' -- it would load the product database into RAM, then the error log. Then it would need a little more memory, so it would throw out the product database....and on forever. Basically it was reloading a 30,000 record database every time someone hit the home page.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court, #453 | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>Does having the embedded search commands in pages have a slowdown effect on >the server? I have one page on our site that has about 7 to 8 searches >going on at: http://www.fishingworld.com/News/.Yes, it slows down at a linear rate based on how many records and how complex the search is. But that's to be expected. If you're getting some kind of exponential or sudden slowdown, I suspect you're on the edge of your RAMDoubler's ability to hold WebSTAR, WebCatalog, and all databases in RAM.Also, make sure your error log is cleared out. One of our sites had 30,000 errors in the log, and WebCatalog was 'thrashing' -- it would load the product database into RAM, then the error log. Then it would need a little more memory, so it would throw out the product database....and on forever. Basically it was reloading a 30,000 record database every time someone hit the home page.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court, #453 | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Grant Hulbert
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:
Silly Question (1997)
New Lawsuit Alleges Unitedhealth/Pacificare Deceived (2006)
Visitor info (2000)
WCS Newbie question (1997)
Great product and great job ! (1997)
Passing Cart variable to subdirectory files? (1997)
[WebDNA] Sort Direction matches the written to file order (2015)
Extended [ConvertChars] (1997)
summ=T (2003)
relational db question (2002)
Cart date/time (2006)
ShowNext truncating passed variable?? (1997)
[searh] or [shownext]problem (1998)
Problems with [Search] param - Mac Plugin b15 (1997)
Date Range Issue (2006)
Setting up shop (1997)
Showif Context combined with Search (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
Convert Chars Q (2000)
Webcat 4 or 4.51 serial URGENT (2005)