Re: Summary search -- speed
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12126
interpreted = N
texte = The summary search command appears very useful for pulling out unique fields,such as the categories in the Tea Room example that ships with 2.0. I'm wondering what type of speed this summary search command has over largedatabases. If the inventory was in the 100K records range, would there be asignificant speed hit for a unique entry summary search? Would I be better offwith a separate data table that kept a unique list of categories, etc? I don't yet have the large inventory database to play with, but I need to planahead for it.ThanksSandy
Associated Messages, from the most recent to the oldest:
The summary search command appears very useful for pulling out unique fields,such as the categories in the Tea Room example that ships with 2.0. I'm wondering what type of speed this summary search command has over largedatabases. If the inventory was in the 100K records range, would there be asignificant speed hit for a unique entry summary search? Would I be better offwith a separate data table that kept a unique list of categories, etc? I don't yet have the large inventory database to play with, but I need to planahead for it.ThanksSandy
Sandra L. Pitner <76501.3521@CompuServe.COM>
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:
RE: Languages (1997)
hmmm (2006)
Webcatalog error, Plug-in for Webstar (1996)
Country & Ship-to address & other fields ? (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
Pithy questions on webcommerce & siteedit (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[BULK] [WebDNA] [BULK] looking for the holy grail of hosting still (2013)
page not found redirect (1999)
Is setting a basic lineitem in the cart really magic? (2000)
save & character in db (2005)
Recording size of uploaded file? (2001)
3 card formulas! (1999)
Help name our technology! (1997)
Wireless WebDNA available today! (2000)
Emailer setup (1997)
automating txt downloads for conversion to webcat db (2006)
BIAP relay (1999)
Just Testing (1997)
randomness (1997)