Re: Help with database strategy
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18070
interpreted = N
texte = >Doesn't WebCat have a 100 field limit? Does anyone have any better ideas on >how to accomplish this?No, there is no limit to the number of fields. There is no limit to the number of databases either, contrary to some misunderstood docs.You may find that a single field can hold a lot of information; for instance, a single 365-character field can represent every day of the year, where a T in position 67 means the room is available on day 67 of the year. But depending on your searching needs, that may not be prudent. If every room has 400 different amenities, then you may indeed need 400 fields. But somehow I think those amenities are broken down into broad categories that fit into relations better.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:
>Doesn't WebCat have a 100 field limit? Does anyone have any better ideas on >how to accomplish this?No, there is no limit to the number of fields. There is no limit to the number of databases either, contrary to some misunderstood docs.You may find that a single field can hold a lot of information; for instance, a single 365-character field can represent every day of the year, where a T in position 67 means the room is available on day 67 of the year. But depending on your searching needs, that may not be prudent. If every room has 400 different amenities, then you may indeed need 400 fields. But somehow I think those amenities are broken down into broad categories that fit into relations better.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/
PCS Technical Support
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:
WebCatalog can't find database (1997)
search across ip/domain addresses? (1998)
RE: WebCatalog2 for NT Beta Request (1997)
Search with Special Chars (1997)
Image download problem (2001)
Trouble with formula.db (1997)
Olin (1998)
RE: Problems reading files created by WC (1997)
$flushcache causes crash (2000)
can WC render sites out? (1997)
WebCatalog sales (1997)
Balancing randomness (2000)
[WebDNA] webdna's svn repositories (2009)
WebCat Hosting - Pricing Question (2002)
[OT] Domain Name Scam (2000)
Encrypt a page/template (2002)
Location of Browser Info.txt file (1997)
9 digit zip (2002)
HTML Editors (1997)
Removing [showif] makes a big difference in speed (1997)