Re: Large databases in WebCat
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14501
interpreted = N
texte = >I've noticed that some searches take longer than others. Ones narrowed>by category and subcategories are much faster than general>webdescription field searches.Yes, probably because of the eq instead of wo>In the general webdescription seraches,>searches on single word seems faster than on phrases. Also, the fewer>results found, the faster.Yes, those all make sense. Multi-word wo searches take longer because they compare each word individually to the whole text of the field, in order to create a ranking similar to Lycos that puts records at the top of the list which contain more matching words.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I've noticed that some searches take longer than others. Ones narrowed>by category and subcategories are much faster than general>webdescription field searches.Yes, probably because of the eq instead of wo>In the general webdescription seraches,>searches on single word seems faster than on phrases. Also, the fewer>results found, the faster.Yes, those all make sense. Multi-word wo searches take longer because they compare each word individually to the whole text of the field, in order to create a ranking similar to Lycos that puts records at the top of the list which contain more matching words.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/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:
Bug - 4.5 (2002)
WebDNA Solutions ... sorry! (1997)
WebCat2: multiple currency support (1997)
IE, Layers, and Select (2002)
AuthNumber, ResponseText etc (2005)
WebDNA for Dummies (OT) (2004)
wierd [cart] action! (1997)
TCP Connect/send and CGI (2003)
WebCatalog2 Feature Feedback (1996)
shopping cart bug? or link? (1999)
Some Questions (1997)
[WebDNA] [grep] bug Crashes WebDNA 6.2 (2014)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
[search] in formulas.db (1997)
What is WebDNA (1997)
Re:listfiles-looking for slick solution (1997)
Why don't my carts expire (1998)
Emailer errors (1997)
Problems with webcat 2.01 for NT (1997)
Server Timeout (2001)