Re: How is it done?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17440
interpreted = N
texte = >When a search includes several different values to be checked in a single >database field, how is the search performed? > >Is the database traversed once from top to botton for each value (thus >moving from top to bottom several times), or is each record checked for >all the values before moving to the next record (thus traversing the db >from top to bottom just once)?The internals of how a search is performed are private and even changed from release to release in favor of better/faster algorithms. Right now it is probably visiting each record once before moving on, although sorting can visit records in an apparently random pattern. Is there some noticeable side-effect you are seeing?Technical Support | ==== eCommerce and Beyond ==== 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:
>When a search includes several different values to be checked in a single >database field, how is the search performed? > >Is the database traversed once from top to botton for each value (thus >moving from top to bottom several times), or is each record checked for >all the values before moving to the next record (thus traversing the db >from top to bottom just once)?The internals of how a search is performed are private and even changed from release to release in favor of better/faster algorithms. Right now it is probably visiting each record once before moving on, although sorting can visit records in an apparently random pattern. Is there some noticeable side-effect you are seeing?Technical Support | ==== eCommerce and Beyond ==== 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/
PCS Technical Support
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:
First postarg not taking in $Commands (1997)
Fwd: Problems with Webcatalog Plug-in (1997)
"The event log file is corrupt" (2003)
Digital Postcards (1999)
Copyright ? (1997)
Locking up with WebCatalog... (1997)
Summing fields (1997)
WebSTAR and WebSTAR/SSL with WebCatalog plugins (1998)
NEWBIE ? help with link (1998)
How do I handle extra spaces? (2002)
[Webcat 2]Next (1997)
Some Questions (1997)
RE: I have observed and I am gone. (1998)
Large File Uploads Impact WebDNA Performance (IIS) (2003)
RE: Jimmy Houssen (1998)
Country & Ship-to address & other fields ? (1997)
Summing fields (1997)
emailer settings and control questions (1997)
Nested tags count question (1997)
How to get shownext to just shownext once (1997)