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

Re: search vs lookup

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17805
interpreted = N
texte = >So far I know database searches are very fast when they perform an indexed search and return just one record. >The WebCat manual claims to use Lookup to get just one field, and it is really fast. >But what is generally faster when I need 2 or 3 fields of one record? >How with small databases (10 records, 5 fields) >How with bigger databases (1000 records, 20 fields)Grant told me that single lookups are fast compared to single searches, but when you need more than a couple of fields, you're better off using a search.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: search vs lookup (Kenneth Grome 1998)
  2. Re: search vs lookup (PCS Technical Support 1998)
  3. search vs lookup (Peter Ostry 1998)
>So far I know database searches are very fast when they perform an indexed search and return just one record. >The WebCat manual claims to use Lookup to get just one field, and it is really fast. >But what is generally faster when I need 2 or 3 fields of one record? >How with small databases (10 records, 5 fields) >How with bigger databases (1000 records, 20 fields)Grant told me that single lookups are fast compared to single searches, but when you need more than a couple of fields, you're better off using a search.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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:

redirecting as post (2001) Calculating multiple shipping... (1997) PCS Frames (1997) RSS Feed (2004) Location of Browser Info.txt file (1997) Date search - yes or no (1997) RE: type 2 errors with ssl server (1997) WebCatalog f2 Installation (1997) emailer (1997) Signal Raised Error (1997) Incrementing a number (1998) Building Calendars (1997) restart needed???? (1997) unix permissions for 4.0 (2000) WebCatalog/Mac 2.1b2 New Features (1997) Webcat 2.0.1 date math bug -> Crash! (1997) user/password validation (1998) Download capabilities (1997) $flushdatabases question ... (1998) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997)