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:
WebMerchant 1.6 and SHTML (1997)
Auth.net and SIM (2003)
newbies to web, spaces in email address (1998)
[CART] (1997)
Test (2000)
Emailer help....! (1997)
database freeze (1997)
Multiple catalog databases and showcart (1997)
WebCatalog2 Feature Feedback (1996)
No luck with taxes (1997)
Question About XML Style Syntax (2000)
WebDelivery downloads alias, not original ? (1997)
How to Sort Summ data ? (1997)
RE: Subtotal help (1997)
Online reference (1997)
Rumpus/Typhoon modules included in Typhoon ... (1997)
Who is doing sign-ups-got it (1998)
WHY SO MANY DUPLICATES? (1999)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Math with Time (1997)