Re: Performance Tuning

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 66497
interpreted = N
texte = Allen Frye wrote: > I'm having some issues with WebDNA maxing out the cpu and I could use > some help tuning webdna. We run webdna 5 on OSX with webstar, dual 1.3 > machine with 4gigs of ram, primarily for one site. Last month we > received 24 million page views, about 1.5 million visitor sessions, and > 300 visitors per hour. You need to realize that the site design is probably at least as important (if not more so) as server tuning. How are you determining that WebDNA is maxing out the CPU and not WebStar? Can you use your server logs to see which page is being viewed most often? Is this a fully dynamic site (where each page is mostly served out of the DB's) or a most static site (where pages have some dynamic content, but most of the processing is serving up static content)? You need to get a good idea for how much CPU is spent rendering the page and how much is spent searching the DB's. One way to do this is to take some subsection of your site and pre-render the pages to fully static content and then see how that affects your overall processing time. > We're in the process of migrating to MySQL and > PHP, but in the meantime any ideas would be appreciated. Don't expect that to automatically be faster, taking into consideration the above discussion. On a page-per-page basis, a RAM resident database is always going to beat a disk-bound database, no matter how slow the RAM searching is (disks are milliseconds and RAM is nanoseconds). John -- 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Performance Tuning ( "kalin mintchev" 2006)
  2. Re: Performance Tuning ( Larry Hewitt 2006)
  3. Re: Performance Tuning ( Donovan Brooke 2006)
  4. Re: Performance Tuning ( "Allen Frye" 2006)
  5. Re: Performance Tuning ( John Peacock 2006)
  6. Performance Tuning ( "Allen Frye" 2006)
Allen Frye wrote: > I'm having some issues with WebDNA maxing out the cpu and I could use > some help tuning webdna. We run webdna 5 on OSX with webstar, dual 1.3 > machine with 4gigs of ram, primarily for one site. Last month we > received 24 million page views, about 1.5 million visitor sessions, and > 300 visitors per hour. You need to realize that the site design is probably at least as important (if not more so) as server tuning. How are you determining that WebDNA is maxing out the CPU and not WebStar? Can you use your server logs to see which page is being viewed most often? Is this a fully dynamic site (where each page is mostly served out of the DB's) or a most static site (where pages have some dynamic content, but most of the processing is serving up static content)? You need to get a good idea for how much CPU is spent rendering the page and how much is spent searching the DB's. One way to do this is to take some subsection of your site and pre-render the pages to fully static content and then see how that affects your overall processing time. > We're in the process of migrating to MySQL and > PHP, but in the meantime any ideas would be appreciated. Don't expect that to automatically be faster, taking into consideration the above discussion. On a page-per-page basis, a RAM resident database is always going to beat a disk-bound database, no matter how slow the RAM searching is (disks are milliseconds and RAM is nanoseconds). John -- 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/ John Peacock

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:

Help formatting search results w/ table (1997) WebCat2final1 crashes (1997) Include a big block of text (1997) triggers (2003) writing db to disk (1997) Range of Reports- go relational or include file? (2000) Problems setting MIME Headers (1998) test for John (1999) WC2.0 Memory Requirements (1997) Cart # Starting at 1000 (2000) File dates in WebCatalog .tmpl/.inc (1997) summ=T (2003) Number of files in a directory (2006) Upgrading old WebCat Database Files (1997) WebDNA Quick Reference (Reserved Words) (2000) RE: Credit card processing - UK (1997) PowerKey and PageSentry not playing nice (2000) webcat- multiple selection in input field (1997) Can't Update records (1997) Shopping Headers (2005)