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:

    
  1. re: Large Database Options? (PCS Technical Support 1999)
  2. Re: Large Database Options? (Bob Minor 1999)
  3. re: Large Database Options? (Juliana Sun 1999)
  4. Re: Large Database Options? (Kenneth Grome 1999)
  5. Re: Large Database Options? (Dave MacLeay 1999)
>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:

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)