Re: Summary search -- speed
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12135
interpreted = N
texte = Yes, that's correct. Obviously there will be some speed hit as the recordsincrease, but the summary command won't aggrevate it as long as the numberof items in the summary list itself increases dramatically.John.>
a large number of records. The only speed hit would occur if the number of>unique values (size of the summary list) became very large (that is,>increased at the same rate as the number of records). If the number of>unique values stays roughly the same as the number of records increases,>there shouldn't be any unecessary speed concerns. I hope this helps.>>>Just to make sure I understand correctly, you are saying that if I have>about 10>-20 unique categories, the speed is the same whether or not I have 100,>1000 or>100,000 records?>>Slowness occurs when the # of unique categories increases drastically from>10-20>to 100's or more?>>Did I get it right?>>Thanks>>SandyJohn A. Hill Pacific Coast Software11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT *San Diego, CA 92128 http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
Yes, that's correct. Obviously there will be some speed hit as the recordsincrease, but the summary command won't aggrevate it as long as the numberof items in the summary list itself increases dramatically.John.>a large number of records. The only speed hit would occur if the number of>unique values (size of the summary list) became very large (that is,>increased at the same rate as the number of records). If the number of>unique values stays roughly the same as the number of records increases,>there shouldn't be any unecessary speed concerns. I hope this helps.>>>Just to make sure I understand correctly, you are saying that if I have>about 10>-20 unique categories, the speed is the same whether or not I have 100,>1000 or>100,000 records?>>Slowness occurs when the # of unique categories increases drastically from>10-20>to 100's or more?>>Did I get it right?>>Thanks>>SandyJohn A. Hill Pacific Coast Software11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT *San Diego, CA 92128 http://www.smithmicro.com
John Hill
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:
WebCat2 Append problem (B14Macacgi) (1997)
[WebDNA] Sorry WebDNA server not running - September 2019 Edition (2019)
Re:E-Mailer (WebCatb15acgiMac) (1997)
Search/sort in URL Was: GuestBook example (1997)
Searching Groups for multiple matches (1998)
webcat and OS 8 (1997)
Extended [Convertchars] needed (1997)
BR (1997)
WebCatalog for Postcards ? (1997)
simple forum/bboard (2004)
WebCatalog usage (1997)
Resume Catalog ? (1997)
ReturnRaw and redirect one last question (1997)
WCS Newbie question (1997)
[WebDNA] EMailFolder/ (2016)
Plugin or CGI or both (1997)
[lineitems] (2000)
[ListFiles] context & alias (1997)
[isfile] ? (1997)
WC2b15 File Corruption (1997)