Re: Search design
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11280
interpreted = N
texte = I'm going to be setting up a web storefront with WebCatalog/Merchant for a newbusiness. I'm designing the datafields for the catalog now. One of my design concerns is maximizing datatable overlap with POS/OE (by EES),a back-end order fulfillment/inventory/accounting system written in 4D. Theyhave a short description field that is limited to 40 characters (they also havea longer paragraph style description field that will be used for the greaterdetail section). The 40 characters is not long enough to fit in all brand andoption information for all items to be carried. If I separate off generalfields like brand and remove the redundant information from the shortdescription field, will I be taking a major performance hit for searching two orthree data fields (ie brand, category of inventory, description) instead of one?The inventory offered will be very large (over 100K items) eventually.The priority is for a novice searcher to enter a keyword that is general orspecific (ie 'monitor' or '17 NEC') and get good results. ThanksSandy Pitner
Associated Messages, from the most recent to the oldest:
I'm going to be setting up a web storefront with WebCatalog/Merchant for a newbusiness. I'm designing the datafields for the catalog now. One of my design concerns is maximizing datatable overlap with POS/OE (by EES),a back-end order fulfillment/inventory/accounting system written in 4D. Theyhave a short description field that is limited to 40 characters (they also havea longer paragraph style description field that will be used for the greaterdetail section). The 40 characters is not long enough to fit in all brand andoption information for all items to be carried. If I separate off generalfields like brand and remove the redundant information from the shortdescription field, will I be taking a major performance hit for searching two orthree data fields (ie brand, category of inventory, description) instead of one?The inventory offered will be very large (over 100K items) eventually.The priority is for a novice searcher to enter a keyword that is general orspecific (ie 'monitor' or '17 NEC') and get good results. ThanksSandy Pitner
Sandra L. Pitner <76501.3521@CompuServe.COM>
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:
Setting up shop (1997)
Using EIMS instead of Emailer (1998)
triggers.db (1999)
[WebDNA] macOS 10.13.3 and WebDNA Mac Server 8.5.1 - hick-up (2019)
[WebDNA] CSS Advice (2008)
Using WC for Bulk Emailings (1997)
Search with Special Chars (1997)
Memory Leak (2000)
Merry Christmas (2002)
Virtual Postcard almost complete... (1998)
OT - help.. (2003)
re: Large Database Options? (1999)
where to put code (1998)
WC1.6 to WC2 date formatting (1997)
Forms to db's and back (2005)
MySQL blob question, Netscape slow question (2002)
Error:Too many nested [xxx] contexts (1997)
WebCatalog for guestbook ? (1997)
Country & Ship-to address & other fields ? (1997)
How to append text after the sign & (1997)