Re: Search wbrk (repost)
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40308
interpreted = N
texte = On 11/26/01 11:06 AM, John Peacock
wrote:> Why do you think that? The SKU has as many records as it has CATegories. The > unique value is SKU+CAT combined; a SKU will have at most one record for any > given CAT, but there can be multiple CAT's per SKU. And of course, the CAT > long description is in another table entirely, so that data is not duped.Well I don't want to get into a lengthy discussion on it, but webcat used to have a limitation of db's open. Which it handles much better now. At any rate one needed to keep the db's to a minimum if one had more than one website. Since we did and do, we designed the system to use one database ieSKU CAT MCAT TITLE DESCRIPTION 1 2 10_2,10_3 Toy Foam and Rubber oh what fun.In this way we could search CAT & MCAT collectively for the value 10_2 or the value 2. MCAT was in essence a table of its own. Now if we designed this without those constraints then yes we could have built that without those contraints. But since this was built 6+ years ago how does your comment help me with the function of word breaks.Additionally since we performed the search on this db, we did not have to do a second search to retrieve further information in another search.For example lets say we are looking for items in the category 10_2, so we set our search that way. It then returns 50 records and we display information from the database like title and description. We can also have any number of categories not limited by the number we set up if we were to use separate fields. If we do the search under your system we now search the cat.db file and return our same 50 records only now we have to do 50 searches to get the Title, Description, price etc.... The latter seems much more processor intesive, I could be wrong though since there is more data to wade through in the first example.Sincerely,Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us! ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
On 11/26/01 11:06 AM, John Peacock wrote:> Why do you think that? The SKU has as many records as it has CATegories. The > unique value is SKU+CAT combined; a SKU will have at most one record for any > given CAT, but there can be multiple CAT's per SKU. And of course, the CAT > long description is in another table entirely, so that data is not duped.Well I don't want to get into a lengthy discussion on it, but webcat used to have a limitation of db's open. Which it handles much better now. At any rate one needed to keep the db's to a minimum if one had more than one website. Since we did and do, we designed the system to use one database ieSKU CAT MCAT TITLE DESCRIPTION 1 2 10_2,10_3 Toy Foam and Rubber oh what fun.In this way we could search CAT & MCAT collectively for the value 10_2 or the value 2. MCAT was in essence a table of its own. Now if we designed this without those constraints then yes we could have built that without those contraints. But since this was built 6+ years ago how does your comment help me with the function of word breaks.Additionally since we performed the search on this db, we did not have to do a second search to retrieve further information in another search.For example lets say we are looking for items in the category 10_2, so we set our search that way. It then returns 50 records and we display information from the database like title and description. We can also have any number of categories not limited by the number we set up if we were to use separate fields. If we do the search under your system we now search the cat.db file and return our same 50 records only now we have to do 50 searches to get the Title, Description, price etc.... The latter seems much more processor intesive, I could be wrong though since there is more data to wade through in the first example.Sincerely,Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us! ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Bob Minor
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:
Emailer setup (1997)
Problem with updating 2.1b7 -> 2.1.1 (1998)
WebCat2 - Getting to the browser's username/password data (1997)
Potential Conflicts? (1997)
Help! WebCat2 bug (1997)
[WebDNA] 6.2.1 fails on Apache 2.4.6 (2014)
Looking For WebCatalog Migration Assistance (2003)
Discounts (2002)
Reversed words (1997)
FEA REQ: One .hdr, multiple .db's (2003)
Nesting format tags (1997)
WCS Newbie question (1997)
Putting [cart] into a database (2003)
Moment of Thanks (1997)
[WebDNA] WebDNA Crashing or Not **YES** (2008)
Integration of PayPal ExpressCheckout (2006)
Multiple security dbs (1997)
WebCat NT v. Mac (1997)
[WebDNA] [middle] (2015)
Search for 20 finds 2000, 200 Why? (1997)