Re: [WebDNA] Not even sure what to ask for help on. . . :(

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101640
interpreted = N
texte = All good ideas and in need of serious thought. I think I will write the main info to a single database, which should decrease the load and complexity greatly. In general, I think this might be a case of all of the above. though I did quadruple the ram today:) thanks all! D. On Tue, Dec 16, 2008 at 2:06 AM, Frank Nordberg wrote: > David Bastedo wrote: >> >> I stream through the same pipe and can handle up to 6mb a second - >> which I have come close to, but not quite attained. The max I have hit >> in the last week is 5.5. > > Pushing that close to the bandwidth limit is never a good idea. This may > well be one cause of the problems but perhaps not the only one. > > --- > > Rob wrote: > >> Which to me means that under normal conditions, low load, your lookups >> are working fine, and everything functions normally. If it was a >> problem in the coding, you would also see it in low load conditions as >> well... yes/no? > > Not necessarily. An actual bug in the code would probably show up regardless > but if it's a case of too complex a code for the server to handle, the scale > of the problem would increase with the load. > > One "problem" with WebDNA is that it's a bit too useful sometimes. It's so > tempting to keep adding another little script and yet another little script > and... > > --- > > Kenneth Grome wrote: > >> How many webdna hits are you getting per minute or second? > > That's a very important question although of course it also depends on the > complexity of the code and the capacity of the server. > > A very rough guide: > + Less than 10 hits pr. minute: > Something's really wrong if you have problems. > > + 10-100 hits pr. minute: > Should work fine unless the code is very complex and/or the server > is old and slow. > > + 100-500 hits pr. minute: > Basic WebDNA functionality should work fine. Serious power required > for advanced stuff. > > + 500-1000 hits pr. minute: > Time to seriously consider code optimisation and perhaps a faster > server. > > + More than 1000 hits pr. minute: > You might want to consider a server cluster. > > --- > > Ken's list of optimisation tips is a very good one (thanks Ken!) Here are a > few more: > > + Make sure you have enough *physical* RAM (virtual memory doesn't count) to > run the software *and* cache all the templates and databases. > This is by far the most important point. Nothing slows the server down more > than reading from and writing to the harddisc. > > + If you use temporary databases, keep them as simple as possible: e.g. just > a a list of reference numbers pointing to a permanent database rather than > all the data needed. > > + Consider splitting large databases into smaller ones. But be careful: do > this the wrong way and you end up increasing the load rather than reducing > it. > > + Consider storing large chunks of text as text files rather than in > databases and use [Include] commands to fetch them. (Another method that may > backfire so be careful.) > > Frank Nordberg > http://www.musicaviva.com > http://stores.ebay.com/Nordbergs-Music-Store?refid=store > http://www.abc-notation.com > http://www.online-guitarist.com > http://www.gitar-siden.com > http://www.tablatvre.com > http://www.mandolin-player.com > http://www.blues-harmonica.com > http://www.irish-banjo.com > http://www.blues-banjo.com > http://www.folk-banjo.com > http://www.roarogfrank.com > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > -- David Bastedo Ten Plus One Communications Inc. http://www.10plus1.com 416.603.2223 ext.1 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Not even sure what to ask for help on. . . :( ("David Bastedo" 2008)
  2. Re: [WebDNA] Not even sure what to ask for help on. . . :( ("David Bastedo" 2008)
  3. Re: [WebDNA] Not even sure what to ask for help on. . . :( (christophe.billiottet@webdna.us 2008)
  4. Re: [WebDNA] Not even sure what to ask for help on. . . :( (Kenneth Grome 2008)
  5. Re: [WebDNA] Not even sure what to ask for help on. . . :( ("David Bastedo" 2008)
  6. Re: [WebDNA] Not even sure what to ask for help on. . . :( (Frank Nordberg 2008)
  7. Re: [WebDNA] Not even sure what to ask for help on. . . :( ("David Bastedo" 2008)
  8. Re: [WebDNA] Not even sure what to ask for help on. . . :( (Kenneth Grome 2008)
  9. Re: [WebDNA] Not even sure what to ask for help on. . . :( (Rob 2008)
  10. Re: [WebDNA] Not even sure what to ask for help on. . . :( ("David Bastedo" 2008)
  11. Re: [WebDNA] Not even sure what to ask for help on. . . :( (Rob 2008)
  12. [WebDNA] Not even sure what to ask for help on. . . :( ("David Bastedo" 2008)
All good ideas and in need of serious thought. I think I will write the main info to a single database, which should decrease the load and complexity greatly. In general, I think this might be a case of all of the above. though I did quadruple the ram today:) thanks all! D. On Tue, Dec 16, 2008 at 2:06 AM, Frank Nordberg wrote: > David Bastedo wrote: >> >> I stream through the same pipe and can handle up to 6mb a second - >> which I have come close to, but not quite attained. The max I have hit >> in the last week is 5.5. > > Pushing that close to the bandwidth limit is never a good idea. This may > well be one cause of the problems but perhaps not the only one. > > --- > > Rob wrote: > >> Which to me means that under normal conditions, low load, your lookups >> are working fine, and everything functions normally. If it was a >> problem in the coding, you would also see it in low load conditions as >> well... yes/no? > > Not necessarily. An actual bug in the code would probably show up regardless > but if it's a case of too complex a code for the server to handle, the scale > of the problem would increase with the load. > > One "problem" with WebDNA is that it's a bit too useful sometimes. It's so > tempting to keep adding another little script and yet another little script > and... > > --- > > Kenneth Grome wrote: > >> How many webdna hits are you getting per minute or second? > > That's a very important question although of course it also depends on the > complexity of the code and the capacity of the server. > > A very rough guide: > + Less than 10 hits pr. minute: > Something's really wrong if you have problems. > > + 10-100 hits pr. minute: > Should work fine unless the code is very complex and/or the server > is old and slow. > > + 100-500 hits pr. minute: > Basic WebDNA functionality should work fine. Serious power required > for advanced stuff. > > + 500-1000 hits pr. minute: > Time to seriously consider code optimisation and perhaps a faster > server. > > + More than 1000 hits pr. minute: > You might want to consider a server cluster. > > --- > > Ken's list of optimisation tips is a very good one (thanks Ken!) Here are a > few more: > > + Make sure you have enough *physical* RAM (virtual memory doesn't count) to > run the software *and* cache all the templates and databases. > This is by far the most important point. Nothing slows the server down more > than reading from and writing to the harddisc. > > + If you use temporary databases, keep them as simple as possible: e.g. just > a a list of reference numbers pointing to a permanent database rather than > all the data needed. > > + Consider splitting large databases into smaller ones. But be careful: do > this the wrong way and you end up increasing the load rather than reducing > it. > > + Consider storing large chunks of text as text files rather than in > databases and use [include] commands to fetch them. (Another method that may > backfire so be careful.) > > Frank Nordberg > http://www.musicaviva.com > http://stores.ebay.com/Nordbergs-Music-Store?refid=store > http://www.abc-notation.com > http://www.online-guitarist.com > http://www.gitar-siden.com > http://www.tablatvre.com > http://www.mandolin-player.com > http://www.blues-harmonica.com > http://www.irish-banjo.com > http://www.blues-banjo.com > http://www.folk-banjo.com > http://www.roarogfrank.com > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > -- David Bastedo Ten Plus One Communications Inc. http://www.10plus1.com 416.603.2223 ext.1 "David Bastedo"

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:

Template transformed itself into a database? (1998) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) [isfolder] and [filename] (1997) Bug: MySQL WebDNA 6 int bigint fail case (2004) ReadDateFormat (1998) matching shipto and others (1998) Email truncation in Eudora. (1998) Help! I've fallen in Structured Query Language and can'tget (2002) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) DataBaseHelper Flawed (1997) [WebDNA] setting up a dev server on Windows 7 or 8? (2014) Re:2nd WebCatalog2 Feature Request (1996) Can you do this??? and other stuff (1997) RE: Emailer Set Up (1997) I'm new be kind (1997) Mac v. NT (1998) b12 cannot limit records returned and more. (1997) [WebDNA] WebDNA Technical Change History (2019) WebMerchant 1.6 and https (1997) Quickie question on the email templates (1997)