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:
Frames and WebCat (1997)
Download capabilities (1997)
Another question (1997)
LetterRip and WebCat & more (1998)
Email Newsletters (2003)
[WebDNA] remove html comments (2009)
webcatalog [date] bug (1999)
2 passwords (2003)
WebCatalog NT beta 18 problem (1997)
anyone know how to restart dbserver on NT automatically (1999)
RE: New WebCatalog Version !!! (1997)
Help with Repost Data msg from form (1997)
Nested Loops and SHOWIFs (1997)
Please ignore, TEST (2001)
[OT] - Credit card processing company fees (2004)
unable to launch acgi in WebCat (1997)
Some pointers please (2008)
Reversed words (1997)
Running 2 two WebCatalog.acgi's (1996)
Re:Dumb Question about Docs (1997)