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 changedfrom release to release in favor of better/faster algorithms. Right now itis probably visiting each record once before moving on, although sortingcan visit records in an apparently random pattern. Is there somenoticeable 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 | Typhoon619/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 changedfrom release to release in favor of better/faster algorithms. Right now itis probably visiting each record once before moving on, although sortingcan visit records in an apparently random pattern. Is there somenoticeable 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 | Typhoon619/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:
[WebDNA] [fileinfo] not working (2014)
no template caching (1997)
Re:listfiles-looking for slick solution (1997)
[WriteFile] problems (1997)
Max Record length (1997)
Quit revisited (1997)
policies, slightly OT (2004)
sendmail and accented characters (1998)
RE:It just Does't add up!!! (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Some ThankYou page problems (1997)
ShowIf variables (1997)
Mozilla/4. and Browser Info.txt (1997)
restart needed???? (1997)
[isfolder] and [filename] (1997)
[WebDNA] User sessions - cookies only or cookies and a sessions.db? (2016)
Configuring E-mail (1997)
Multiple prices (1997)
Weird WebCatalog problems (1998)
[Webcat 2]Next (1997)