Re: WebDNA 4.5.1 Now Available
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47097
interpreted = N
texte = Well, I do not have an exact method, but try this...During periods of your heaviest server loads, check the amount of available 'physical' memory on your server. Estimate the amount of RAM required for n number of 'extra' databases that might be loaded as a result of increasing the Database cache size (above the default 100). Since there is no way to predict which of your databases might be loaded into the extra cache space, I would just add 'n' number of your larger db files. If the amount of 'available' physical memory, is greater than or equal to your database sum * 1.25 (allowing for cache and search overhead - a very rough guess), you should be okay.I am sure we will refine this method as we get more feedback from WebDNA users who increase the db cache size.----- Original Message ----- From:
To: WebCatalog Talk Sent: Wednesday, January 22, 2003 11:00 AM Subject: Re: WebDNA 4.5.1 Now Available Can you give us hint on what the requirements are so we can avoid trial and error?Thanks.-----Original Message----- From: Scott Anderson Sent: Wed, 22 Jan 2003 10:21:44 -0800 To: (WebCatalog Talk) Subject: Re: WebDNA 4.5.1 Now AvailableWe've just added the ability to override the built in cache size limit of 100, for both the database and template caches. However, just because you set the cache size to 200 on your machine, doesn't mean that you have the resources to fit 200 of your databases in the cache. So it will take a little bit of trial and error to determine the optimum setting for a particular server. If 200 is causing database errors, then drop it down to 185, 175, etc... Future versions of the engine will have the ability to handle situations where the cache size setting is too high for available resources. This was just a quick way to give those customers, who have lots of available RAM, the ability to bump up the cache sizes.> -----Original Message----- > From: WebCatalog Talk > [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf > Of Nitai @ ComputerOil > Sent: Wednesday, January 22, 2003 2:55 AM > To: WebCatalog Talk > Subject: Re: WebDNA 4.5.1 Now Available > > > On 22.1.2003 9:56 AM, Alain Russell > > wrote: > > > About 140 .. > > My top output below .. > > > > 1827 WebCatalog 1.8% 1:40.31 4 60 108 37.3M > 1.12M 38.1M 56.9M > > 1826 WebDNAMoni 0.0% 0:00.01 2 17 14 48K > 312K 260K 1.75M > > > > Alain > > > > What else runs on your server .. ? > > Only WebDNA and Post Office. > > During beta, I have set the db pref to 200 and then hit walls > after 200 db's > were open. WebDNA reported that it cant open db's anymore. > Maybe they have > fixed that issue in the meantime. > > Scott, can you straighten this out:-) > > Sincerely, > Nitai Aventaggiato > CEO > > -- > Tools to energize your business > Content Management & eBusiness Systems > > ComputerOil GmbH http://computeroil.com/ > Unionstrasse 4 info@computeroil.com > 8032 Zürich/Switzerland > Tel: +41 (0)43 333 1 555 > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/------------------------------------------------------------- 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/ ------------------------------------------------------------- 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:
Well, I do not have an exact method, but try this...During periods of your heaviest server loads, check the amount of available 'physical' memory on your server. Estimate the amount of RAM required for n number of 'extra' databases that might be loaded as a result of increasing the Database cache size (above the default 100). Since there is no way to predict which of your databases might be loaded into the extra cache space, I would just add 'n' number of your larger db files. If the amount of 'available' physical memory, is greater than or equal to your database sum * 1.25 (allowing for cache and search overhead - a very rough guess), you should be okay.I am sure we will refine this method as we get more feedback from WebDNA users who increase the db cache size.----- Original Message ----- From: To: WebCatalog Talk Sent: Wednesday, January 22, 2003 11:00 AM Subject: Re: WebDNA 4.5.1 Now Available Can you give us hint on what the requirements are so we can avoid trial and error?Thanks.-----Original Message----- From: Scott Anderson Sent: Wed, 22 Jan 2003 10:21:44 -0800 To: (WebCatalog Talk) Subject: Re: WebDNA 4.5.1 Now AvailableWe've just added the ability to override the built in cache size limit of 100, for both the database and template caches. However, just because you set the cache size to 200 on your machine, doesn't mean that you have the resources to fit 200 of your databases in the cache. So it will take a little bit of trial and error to determine the optimum setting for a particular server. If 200 is causing database errors, then drop it down to 185, 175, etc... Future versions of the engine will have the ability to handle situations where the cache size setting is too high for available resources. This was just a quick way to give those customers, who have lots of available RAM, the ability to bump up the cache sizes.> -----Original Message----- > From: WebCatalog Talk > [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf > Of Nitai @ ComputerOil > Sent: Wednesday, January 22, 2003 2:55 AM > To: WebCatalog Talk > Subject: Re: WebDNA 4.5.1 Now Available > > > On 22.1.2003 9:56 AM, Alain Russell > > wrote: > > > About 140 .. > > My top output below .. > > > > 1827 WebCatalog 1.8% 1:40.31 4 60 108 37.3M > 1.12M 38.1M 56.9M > > 1826 WebDNAMoni 0.0% 0:00.01 2 17 14 48K > 312K 260K 1.75M > > > > Alain > > > > What else runs on your server .. ? > > Only WebDNA and Post Office. > > During beta, I have set the db pref to 200 and then hit walls > after 200 db's > were open. WebDNA reported that it cant open db's anymore. > Maybe they have > fixed that issue in the meantime. > > Scott, can you straighten this out:-) > > Sincerely, > Nitai Aventaggiato > CEO > > -- > Tools to energize your business > Content Management & eBusiness Systems > > ComputerOil GmbH http://computeroil.com/ > Unionstrasse 4 info@computeroil.com > 8032 Zürich/Switzerland > Tel: +41 (0)43 333 1 555 > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/
Scott Anderson
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:
[returnraw] and form variables (1998)
Intermitent problem using [referrer] (1997)
month or year from date field in lineitems? (1998)
[WriteFile] problems (1997)
[replaceChars] would be nice ... (1997)
database editor add field, etc. (2005)
Stat analyzer (1997)
Showif, Hideif reverse logic ? (1997)
[searchString] (1997)
Calculating multiple shipping... (1997)
SERIAL NUMBER PROBLEM *AGAIN*!!! (1998)
Another pair of eyes?? (2006)
WebDNA Commerce Single for MAC 6.0 (2008)
2nd try:Webcat interfering with Webstar? (1998)
[WebDNA] Database Error -oRiGiNaL- (2012)
[isfile] ? (1997)
Store Builder Weirdness (1999)
using showpage and showcart commands (1996)
shownext (1997)
Attention all list readers (1997)