re: Large Database Options?
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22473
interpreted = N
texte = >We are in process of adding more memory to handle the db but I anticipate >that I will run into the same problem later on. This database was provided >by one of our suppliers. I will need to integrate databases from 4 or 5 >more suppliers once I get this working. I was just looking for some other >options in conjunction with throwing more memory at the system.There are certain hybrid approaches you can take, one of them being to use the [SQL] context to grab information that is less-frequently used (such as product descriptions, customer history, etc.). That way you keep the necessary high-speed data in WebCatalog's fast-access RAM-based areas, and you maintain the other slower data in the slower back-end databases like SQL.Also, we've found that many people get databases with huge numbers of trailing spaces in them (a holdover from the old mainframe days) and simply stripping those will shrink the RAM footprint of WebCatalog significantly. Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>We are in process of adding more memory to handle the db but I anticipate >that I will run into the same problem later on. This database was provided >by one of our suppliers. I will need to integrate databases from 4 or 5 >more suppliers once I get this working. I was just looking for some other >options in conjunction with throwing more memory at the system.There are certain hybrid approaches you can take, one of them being to use the
[SQL] context to grab information that is less-frequently used (such as product descriptions, customer history, etc.). That way you keep the necessary high-speed data in WebCatalog's fast-access RAM-based areas, and you maintain the other slower data in the slower back-end databases like SQL.Also, we've found that many people get databases with huge numbers of trailing spaces in them (a holdover from the old mainframe days) and simply stripping those will shrink the RAM footprint of WebCatalog significantly. Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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)
Greeting Card System (2000)
counters from other site? (1998)
Log-in Scheme (2003)
max page views Mac can handle (1999)
RE: [sendmail]- bcc? (1998)
Protecting webdelivery (1997)
[WebDNA] Emailer & SMTP (2009)
WebCatalog-NT?'s (1996)
[WebDNA] Business Discussions (2008)
Slow Code, how to speed up (2002)
Parameter Passing (2000)
WC2b15 File Corruption (1997)
Lost and Recovered. (1998)
Simple counter - how? (1997)
emailer (1997)
PCS Frames (1997)
Date Formats (1997)
E-mail loop ! (1997)
Emailer setup (1997)