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 usethe [SQL] context to grab information that is less-frequently used (such asproduct descriptions, customer history, etc.). That way you keep thenecessary high-speed data in WebCatalog's fast-access RAM-based areas, andyou maintain the other slower data in the slower back-end databases likeSQL.Also, we've found that many people get databases with huge numbers oftrailing spaces in them (a holdover from the old mainframe days) and simplystripping 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 | Typhoon619/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 usethe
[SQL] context to grab information that is less-frequently used (such asproduct descriptions, customer history, etc.). That way you keep thenecessary high-speed data in WebCatalog's fast-access RAM-based areas, andyou maintain the other slower data in the slower back-end databases likeSQL.Also, we've found that many people get databases with huge numbers oftrailing spaces in them (a holdover from the old mainframe days) and simplystripping 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 | Typhoon619/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:
international time (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Help with update to 2.11 (1998)
WebCat2: Items xx to xx shown, etc. (1997)
Writing to PDF (2003)
Practice runs ? (1997)
[include ...] behavior (1997)
Variables in a Prefernce File (2005)
close to comparison (2000)
searchable list archive (1997)
Press Release hit the NewsWire!!! (1997)
carriage returns in data (1997)
More on the email templates (I like it) (1997)
Not reading code (1997)
problems with 2 tags shakur (1997)
Fun with Dates - finally resolved but.... (1997)
rotating thumbnails (1997)
[WebDNA] a major shift in strategy? (2008)
Bad Cookie / Internet Option / Internet Explorer (2004)
Unauthorized User trouble (1998)