[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:
No messages for a week? (2000)
Applescript, WebDNA, and PDF (1997)
Database Connectivity (1999)
WebCat2 several catalogs? (1997)
New index for docs (1997)
webcat- multiple selection in input field (1997)
[WebDNA] Webserver does not respond occasionally (2018)
WebCatalog 4.0 & Tenon iTools (2000)
RE: NewCart+Search with one click ? (1997)
writing orders to a db (1997)
off topic - dna snipets (1997)
post (2000)
Banners (1997)
Country & Ship-to address & other fields ? (1997)
Secure Server basic question... (1997)
corrupted images (2002)
Updating product information (2002)
Plugin or CGI or both (1997)
RE: creating writefile data from a nested search (1997)
Shopping Cart Limits? (1998)