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

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17070
interpreted = N
texte = >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?The downside of that is you can't easily create a popup or list or any other construct that would require breaking out every word as an individual item (that's why our admin pages can't display a list of Groups). The upside is that it's faster for searching, and in many ways easier to comprehend (and edit) because the words are just sitting there in a single field.There's nothing stopping you from doing both - create a category database whose purpose is to ease popup/list creation, but also have lists of words in a big field. The only problem would be someday getting the two out of synch, but I don't really know what your application is, so I don't know if that's a huge problem.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== 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)
>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?The downside of that is you can't easily create a popup or list or any other construct that would require breaking out every word as an individual item (that's why our admin pages can't display a list of Groups). The upside is that it's faster for searching, and in many ways easier to comprehend (and edit) because the words are just sitting there in a single field.There's nothing stopping you from doing both - create a category database whose purpose is to ease popup/list creation, but also have lists of words in a big field. The only problem would be someday getting the two out of synch, but I don't really know what your application is, so I don't know if that's a huge problem.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== 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/ 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:

There's a bug in the math context ... (1997) Return records from another (1997) More on the email templates (I like it) (1997) This message couldn't reach the list! (multi-column (1998) Suddenly can't see files... (2000) Country & Ship-to address & other fields ? (1997) Listfiles (1998) Major Security Hole (1998) [tcp connect]-dumb question? (1998) slow site (2003) Providing hard copy of database to client (1997) WebCat2 - storing unformatted date data? (1997) [SearchString] problem with [search] context (1997) -tmp files (2000) Showif Context combined with Search (1997) List archive status? (1999) WC Database Format (1997) Grep (2003) OT-Load balance (2004) SendMail (2006)