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:
Web-based email solution (2003)
Looking for a host (1997)
problems with 2 tags (1997)
RE: [WebDNA] Styling search results (2009)
Banners (1997)
Trouble with formula.db (1997)
WebCat2b15MacPlugin - showing [math] (1997)
international time (1997)
WebCatalog for Postcards ? (1997)
Why is this search finding the right thing?! (2002)
Re:Has this happened to you? (was:Emailer Chokes on bad address) (1997)
FYI: virus alert (1996)
Is there a max number of fields? (1998)
taxTotal, grandTotal (1997)
[WebDNA] File Include HTM (2008)
NY taxRates.db? (1997)
multiple search commands (1997)
[CART] inside a [LOOP] (1997)
Last version of webcatalog (2001)
Trigger Problems (2001)