Re: WC2.0 Memory Requirements

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 10261
interpreted = N
texte = >Does anyone have any experience with the additional memory overhead when >splitting a database file into 2 or more with WC 2.0. ClubMac appears to >be running several large WC databases - does anyone know the memory >configuration of their server. Actually the RAM usage is less on WC2, because you're not forced to have all 27 fields in a database. There is some overhead involved for every field added to a database, so if you keep it down to the minimum necessary fields you will save a lot of RAM. Here's the RAM equation for a single database: (size of db file on disk) + (#records * #fields * 4)Having 2 separate db files open is no different than having 1 db file containing both databases. Except it's faster to search just the 1 database you're interested in.>I have also noticed some comment on the Webstar list about WC loading >another copy of the databases when a Webstar SSL transaction is invoked. This only applies to plugins. If you run WC2 as a CGI it's not an issue. And we're working on a plan to get plugins working the same way (probably not until the following release though).Grant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: WC2.0 Memory Requirements (Grant Hulbert 1997)
  2. Re: WC2.0 Memory Requirements (Rob Schmidt 1997)
  3. Re: WC2.0 Memory Requirements (Grant Hulbert 1997)
  4. WC2.0 Memory Requirements (plake 1997)
>Does anyone have any experience with the additional memory overhead when >splitting a database file into 2 or more with WC 2.0. ClubMac appears to >be running several large WC databases - does anyone know the memory >configuration of their server. Actually the RAM usage is less on WC2, because you're not forced to have all 27 fields in a database. There is some overhead involved for every field added to a database, so if you keep it down to the minimum necessary fields you will save a lot of RAM. Here's the RAM equation for a single database: (size of db file on disk) + (#records * #fields * 4)Having 2 separate db files open is no different than having 1 db file containing both databases. Except it's faster to search just the 1 database you're interested in.>I have also noticed some comment on the Webstar list about WC loading >another copy of the databases when a Webstar SSL transaction is invoked. This only applies to plugins. If you run WC2 as a CGI it's not an issue. And we're working on a plan to get plugins working the same way (probably not until the following release though).Grant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 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:

I give up!! (1997) ShipCost Problems (1998) Email Newsletters (2003) NewCart+Search with one click ? (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) WebCatalog can't find database (1997) Monthly Help File (1997) [WebDNA] Combining searches with blank and zero values? (2011) Search in 2 or more catalogs (1997) Add - optional parameters textA=.... (1997) WebCat2final1 crashes (1997) ReadDateFormat bug in 3.x (1998) Safari browser and WebDNA set-cookies (2003) Re1000001: Setting up shop (1997) Execute Applescript (1997) WebCatalog2 Feature Feedback (1996) RE: Multiple Stores and WebCatalog Prefs (1997) Using Plug-In while running 1.6.1 (1997) WebCat2 several catalogs? (1997) Serving images from databases (1998)