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:

    
  1. Re: How is it done? (Kenneth Grome 1998)
  2. Re: How is it done? (PCS Technical Support 1998)
  3. Re: How is it done? (PCS Technical Support 1998)
  4. Re: How is it done? (Trevor Crist 1998)
  5. Re: How is it done? (Kenneth Grome 1998)
  6. Re: How is it done? (Kenneth Grome 1998)
  7. Re: How is it done? (PCS Technical Support 1998)
  8. Re: How is it done? (Kenneth Grome 1998)
  9. Re: How is it done? (PCS Technical Support 1998)
  10. How is it done? (Kenneth Grome 1998)
>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:

Bad suffix error (1997) Using Plug-In while running 1.6.1 (1997) Duplicate Messages (1998) Adding a month and the 31st (bug?) (2002) Still Learning (1997) Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997) Search/sort in URL Was: GuestBook example (1997) apostrophe in search item (1997) cart info (1998) Is [thisurl] http or https? (1998) WebCat2.0b15-to many nested [xx] tags (1997) [writefile] (1997) [shownext] not displaying anything but first indices found (2000) [url] (1997) formula??? (2000) Job Posting (1998) ImageMagick on OSX (2003) HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) Mac 2.1b4 unknown error: BadSuffix (1997) using showpage and showcart commands (1996)