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:
>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:
Extended [ConvertChars] (1997)
WebCatalog2 Feature Feedback (1996)
Serial Number Question (1997)
Memory Parameters (1998)
bounces (2008)
Referrer from multiple entry points (1998)
Refering page (1998)
[CONVERTCHARS] suggestion (2000)
[WebDNA] WebDNA 8.2 and BioType (2016)
[WebDNA] WebDNA 7 (2011)
Before I Can Begin . . . (1998)
WebDNA-Talk Digest mode broken (1997)
absolute paths for databases? (1997)
[tcp connect] (1998)
OT: WebDNA and LINUX (2004)
Logging purchases (1997)
TaxRate and ShipCost Problem (1998)
What about this [delete] situation? (1998)
[WebDNA] Foreign characters (2009) (2009)
Country & Ship-to address & other fields ? (1997)