What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

[WebDNA] Lookup vs. Search

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103048
interpreted = N
texte = --Boundary-00=_nTxbKl9vZoM1VU1 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi Chris, Grant also said doing a case-sensitive search is almost as fast as a lookup, so this is something else to take into consideration when deciding which approach to use. Lookups are case-sensitive by default. Nothing can change this. But if a lookup is possible then a faster case- sensitive search is also possible by adding "&[fieldname]case=T" to your search string. It would be interesting to see lookups compared with case- sensitive searches in version 6.2. This more of an apples- to-apples comparison since they are both case sensitive, and I think the results would be informative. Chris, apparently you're already setup to do these comparisons since you've been posting results. Any chance of you doing a case-sensitive comparison like this? Sincerely, Ken Grome --Boundary-00=_nTxbKl9vZoM1VU1 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi Chris,


Grant also said doing a case-sensitive search is almost as fast as a lookup, so this is something else to take into consideration when deciding which approach to use.


Lookups are case-sensitive by default. Nothing can change this. But if a lookup is possible then a faster case-sensitive search is also possible by adding "&[fieldname]case=T" to your search string.


It would be interesting to see lookups compared with case-sensitive searches in version 6.2. This more of an apples-to-apples comparison since they are both case sensitive, and I think the results would be informative.


Chris, apparently you're already setup to do these comparisons since you've been posting results. Any chance of you doing a case-sensitive comparison like this?


Sincerely,
Ken Grome


--Boundary-00=_nTxbKl9vZoM1VU1-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Lookup vs. Search (Kenneth Grome 2009)
  2. Re: [WebDNA] Lookup vs. Search (Frank Nordberg 2009)
  3. Re: [WebDNA] Lookup vs. Search (christophe.billiottet@webdna.us 2009)
  4. [WebDNA] Lookup vs. Search (Kenneth Grome 2009)
  5. Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (christophe.billiottet@webdna.us 2009)
  6. Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (Kenneth Grome 2009)
  7. Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (christophe.billiottet@webdna.us 2009)
  8. [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (Frank Nordberg 2009)
--Boundary-00=_nTxbKl9vZoM1VU1 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi Chris, Grant also said doing a case-sensitive search is almost as fast as a lookup, so this is something else to take into consideration when deciding which approach to use. Lookups are case-sensitive by default. Nothing can change this. But if a lookup is possible then a faster case- sensitive search is also possible by adding "&[fieldname]case=T" to your search string. It would be interesting to see lookups compared with case- sensitive searches in version 6.2. This more of an apples- to-apples comparison since they are both case sensitive, and I think the results would be informative. Chris, apparently you're already setup to do these comparisons since you've been posting results. Any chance of you doing a case-sensitive comparison like this? Sincerely, Ken Grome --Boundary-00=_nTxbKl9vZoM1VU1 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi Chris,


Grant also said doing a case-sensitive search is almost as fast as a lookup, so this is something else to take into consideration when deciding which approach to use.


Lookups are case-sensitive by default. Nothing can change this. But if a lookup is possible then a faster case-sensitive search is also possible by adding "&[fieldname]case=T" to your search string.


It would be interesting to see lookups compared with case-sensitive searches in version 6.2. This more of an apples-to-apples comparison since they are both case sensitive, and I think the results would be informative.


Chris, apparently you're already setup to do these comparisons since you've been posting results. Any chance of you doing a case-sensitive comparison like this?


Sincerely,
Ken Grome


--Boundary-00=_nTxbKl9vZoM1VU1-- Kenneth Grome

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:

RE: WebCatalog2 for NT Beta Request (1997) Searching/sorting dates (1997) Question about replacing words (1998) Here we go again... was: DDEConnect not working (2006) can WC render sites out? (1997) Hello??? (1997) Logical and or in [hideif] (1997) [WebDNA] Issue with including functions (2011) Dreamweaver UltraDev (2000) Authorize.Net and AIM (2004) RePost: NAT and the CART (1999) Frames and WebCat (1997) Press Release hit the NewsWire!!! (1997) [WebDNA] Not even sure what to ask for help on. . . :( (2008) Multi-processor Mac info ... (1997) Using [sendmail] for mass mailings (2001) WebCat cannot handle compatible search parameters? (1997) synching databases on multiple servers (1997) Country & Ship-to address & other fields ? (1997) Price Not Appearing (2000)