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 | Typhoon 619/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 | Typhoon 619/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:
Showif with an or (2003)
carriage returns in data (1997)
database visibility (2000)
Contexts and Ampersands (1997)
Postgresql books/resources? (2002)
Languages (1997)
Errata: WCS Newbie question (1997)
[WebDNA] HTTP Streaming -- impossible? (2010)
New install permissions (2003)
Directory Overload (1998)
Review comparison by PC Magazine: Open for On-line Business (1997)
Webcat Hosting in London or UK (2003)
[TEXT SECURE=T] (2000)
wierd [cart] action! (1997)
Removing [showif] makes a big difference in speed (1997)
Quitting WebMerchant ? (1997)
help with duplicate records posted (1998)
RE: completed orders database (1997)
can WC render sites out? (1997)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)