[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:

Re: [lookup] vs. [search] (Kenneth Grome 1998)
Re: [lookup] vs. [search] (Grant Hulbert 1998)
[lookup] vs. [search] (Kenneth Grome 1998)

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!

[lookup] vs. [search]

1998

Top Articles:

Related Readings: