Re: Db design question (relational vs. flat?)

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17057
interpreted = N
texte = Thanks!What if I stuff all the category names into the category field in my catalog.txt instead of creating another db like category.db? Can you help me understand pros and cons of one vs. the other?TIA,Dale Stokdyk dstokdyk@dvs.mv.com >>I'd like to have certain products show up in more than one product >>category: > >>1) using the current category field, include all the appropriate category >>names then [search] the category field for the desired cateogry and >>return True when found > >This is certainly the fastest in terms of search speed and data entry -- >it's what we use for groups in the Users.db for the [protect] tag. The >only downside is that someday you may want some automatic way to display a >list of all such categories, and there is no easy way to grab those words >as separate chunks once they're all stuffed into one big field. > >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: Db design question (relational vs. flat?) (Grant Hulbert 1998)
  2. Re: Db design question (relational vs. flat?) (Dale Stokdyk 1998)
  3. Re: Db design question (relational vs. flat?) (PCS Technical Support 1998)
  4. Db design question (relational vs. flat?) (Dale Stokdyk 1998)
Thanks!What if I stuff all the category names into the category field in my catalog.txt instead of creating another db like category.db? Can you help me understand pros and cons of one vs. the other?TIA,Dale Stokdyk dstokdyk@dvs.mv.com >>I'd like to have certain products show up in more than one product >>category: > >>1) using the current category field, include all the appropriate category >>names then [search] the category field for the desired cateogry and >>return True when found > >This is certainly the fastest in terms of search speed and data entry -- >it's what we use for groups in the Users.db for the [protect] tag. The >only downside is that someday you may want some automatic way to display a >list of all such categories, and there is no easy way to grab those words >as separate chunks once they're all stuffed into one big field. > >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/ Dale Stokdyk

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:

cc auth with [purchase] (1998) WC2.0 Memory Requirements (1997) ShippingCosts (1998) [delete] problem (1997) Formating Tables w/[founditems] (1998) Director 7 (1999) Part Html part WebDNA (1997) Comments in db? (1997) SQL speed issues (2001) [WebDNA] Listfiles and sort order (2010) Secure server question (1997) Upload Progress Bar (2003) [subtotal] and others (1997) RE: Still Learning (1997) File Upload, Browser Timeout (2003) webcat- multiple selection in input field (1997) RE: Automatic thumbnail images (1998) WC2b15 File Corruption (1997) RE: OK, here goes... (1997) [WebDNA] Pretty URLS (2011)