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:
Images do not upload completely ... (2003)
[WebDNA] Formatting numbers - truncation instead of rounding (2011)
WebDNA won't start on reboot (2003)
Errata: WCS Newbie question (1997)
Testing the WebCat Email List Members (2000)
RE: Can a database get stomped by simultaneous access? (1997)
The Solution to RE: Unexceling (was I need a smart quote...) (1999)
HTML encoding in URLs (1997)
quickfix for view cart in storebuilder ??? (2002)
Help! WebCat2 bug (1997)
TemplateCacheSize preference (1998)
How true is this? (1999)
emailer settings and control questions (1997)
WebCat2: multiple currency support (1997)
Using Applescript to process WebCatalog functions (1998)
How To question on setting up downloads (1997)
test (2005)
Sorting by date (1997)
[protect] on NT? (1997)
Forms Search Questions (1997)