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 anyother construct that would require breaking out every word as an individualitem (that's why our admin pages can't display a list of Groups). Theupside is that it's faster for searching, and in many ways easier tocomprehend (and edit) because the words are just sitting there in a singlefield.There's nothing stopping you from doing both - create a category databasewhose purpose is to ease popup/list creation, but also have lists of wordsin a big field. The only problem would be someday getting the two out ofsynch, but I don't really know what your application is, so I don't know ifthat'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 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>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 anyother construct that would require breaking out every word as an individualitem (that's why our admin pages can't display a list of Groups). Theupside is that it's faster for searching, and in many ways easier tocomprehend (and edit) because the words are just sitting there in a singlefield.There's nothing stopping you from doing both - create a category databasewhose purpose is to ease popup/list creation, but also have lists of wordsin a big field. The only problem would be someday getting the two out ofsynch, but I don't really know what your application is, so I don't know ifthat'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 | Typhoon619/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)