Re: Search design
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11282
interpreted = N
texte = >will I be taking a major performance hit for searching two or>three data fields (ie brand, category of inventory, description) instead of one?>The inventory offered will be very large (over 100K items) eventually.No, that will scale pretty linearly, and searches should be quite fast. ClubMac does a similar thing so you can type either a description or a part number into a single field and search both fields at once.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors =====Pacific Coast Software | WebCatalog Pro, WebCommerce Solution11770 Bernardo Plaza Court, #453 | SiteEdit Pro, SiteCheck, PhotoMasterSan Diego, CA 92128 | SiteGuard619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>will I be taking a major performance hit for searching two or>three data fields (ie brand, category of inventory, description) instead of one?>The inventory offered will be very large (over 100K items) eventually.No, that will scale pretty linearly, and searches should be quite fast. ClubMac does a similar thing so you can type either a description or a part number into a single field and search both fields at once.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors =====Pacific Coast Software | WebCatalog Pro, WebCommerce Solution11770 Bernardo Plaza Court, #453 | SiteEdit Pro, SiteCheck, PhotoMasterSan Diego, CA 92128 | SiteGuard619/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:
Database Fields (1997)
[listfiles] problems (1997)
Verifying both name and password (was: New Problem) (1997)
http or https (2005)
Re:[input] context (1999)
WebDNA Writer Needed (1997)
OS X Problem... (2000)
RE: [WebDNA] Still having problems (2008)
RE: Problem (1997)
RE: creating writefile data from a nested search (1997)
Help! WebCat2 bug (1997)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
Mac: [ListFiles] bug alert (1997)
Bug Report, maybe (1997)
Follow-up to listfiles bug report ... (2003)
[WebDNA] Where's that developer list? (2012)
New Site Announcement (1998)
shipcost (1997)
retail and wholesale... (2000)
F2 to F3 rocky transition (1997)