search vs lookup

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17791
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)Peter __________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21 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)Peter __________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21 Peter Ostry

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:

blank page from template (1997) Shipping.db (1998) OT: OSX calculator error (2004) TCPConnect to query for Domain expiration (2000) Fields font size (2003) OT: Need (a tiny bit) of help setting up MySQL (2000) syntax question, not in online refernce (1997) Reload of the shoppingcart.tmpl page (1999) Quickie question on the email templates (1997) [WebDNA] Limits? (2009) Re2: frames & carts (1997) Referrer (2000) target=_blank and form variables (1997) Re[2]: Bugs still *not* fixed as promised ... (2000) Ampersand Character (&) (1997) Running 2 two WebCatalog.acgi's (1996) SV: Mass Mail (2000) 'page impression' techniques for banner ads (1999) IIS alert from source W3SVC (2000) [WebDNA]