[lookup] vs. [search]
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16524
interpreted = N
texte = Grant, what would you guess is the break-even point, in terms of speed and/or processing demands, between using a series of lookups and using a search context?Here's what I'm getting at. Let's say, for example, that I want to display some of the field data in a user's database record.Now, I can obviously do it more *easily* with a search context, especially when there's more than one or two fields values I want to display. The search syntax is just easier to write when there are more than a couple of field values to be retrieved from the same db record.But maybe I can use 10 or 20 lookups in place of that search, and maybe those lookups will display faster than if I had used an equivalent search context.I think a series of lookups would be faster, but only to a point. Because with too many lookups, the sheer number of those lookups will likely slow WebCat down more than a single search.So my question is this:What would you guess is the cutoff point where a search context actually becomes equally as fast as a series of lookups? Would that break-even point come when displaying data from 10 fields? 100 fields? 1000 fields? More?Or would it actually be faster to use a search whenever there are more than only one or two field values to display?Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
Grant, what would you guess is the break-even point, in terms of speed and/or processing demands, between using a series of lookups and using a search context?Here's what I'm getting at. Let's say, for example, that I want to display some of the field data in a user's database record.Now, I can obviously do it more *easily* with a search context, especially when there's more than one or two fields values I want to display. The search syntax is just easier to write when there are more than a couple of field values to be retrieved from the same db record.But maybe I can use 10 or 20 lookups in place of that search, and maybe those lookups will display faster than if I had used an equivalent search context.I think a series of lookups would be faster, but only to a point. Because with too many lookups, the sheer number of those lookups will likely slow WebCat down more than a single search.So my question is this:What would you guess is the cutoff point where a search context actually becomes equally as fast as a series of lookups? Would that break-even point come when displaying data from 10 fields? 100 fields? 1000 fields? More?Or would it actually be faster to use a search whenever there are more than only one or two field values to display?Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://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:
Multiple results (2001)
Document Contains No Data! (1997)
[OT] On a side note.. (2003)
NT beta ReadMe missing (b12-b15) (1997)
Re:Can anyone help me with this shipping thing? (1998)
Assigning new CART number (1997)
Alternating colors (1997)
redirect with more than 256 characters (1999)
UPDATE PROBLEM (1997)
no [search] with NT (1997)
Rams SuperBowl Champs (2000)
Grouping Fields (2006)
[OT] - Messed up me user permissions - help ! (2004)
two unique banners on one page (1997)
New commands in Final candidate (1997)
HomePage Caution (1997)
Opinion: [input] should be called [output] ... (1997)
emailer (1997)
There's a bug in the math context ... (1997)
Multiple Ad databases? (1997)