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:
Running _every_ page through WebCat-error.html (1997)
[WebDNA] random blank results? how come? (2014)
Working HTML email (2001)
Snake Bites (1997)
[format xs] freeze (1997)
RE: WebCat: Access denied, but why? (1997)
E-mail formating question (1999)
Last Record not recognized? (1999)
Multiple prices (1997)
WebCat2 Append problem (B14Macacgi) (1997)
View order not right (1997)
WebCat2 - [format thousands] (1997)
sorting on date in search (2000)
Running on Empty (1999)
Re(2): grep matching (2003)
Debug mode (1999)
WebCat2 - storing unformatted date data? (1997)
taxTotal confusion (1998)
Credit card processing - UK (1997)
Parsing args without ? (2003)