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 records increase, but the summary command won't aggrevate it as long as the number of 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 > >Sandy John A. Hill Pacific Coast Software 11770 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 records increase, but the summary command won't aggrevate it as long as the number of 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 > >Sandy John A. Hill Pacific Coast Software 11770 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:
Calendar (1997)
[removehtml] (was: Undocumented tags and contexts) (2000)
Emailer (1997)
Wanted: Broader string manipulation functions (1997)
Sorry WebDNA server not running (2002)
[OT] Redhat 6.1 (2003)
suffix mapping for NT? (1997)
ShowNext Command (1997)
WC2b15 File Corruption (1997)
quantity minimum problem (1997)
[WebDNA] Sorry WebDNA server not running /Template ERROR/ Slow speeds (2019)
charging? (2001)
RE: [WebDNA] test 2 (2019)
Problem upgrading from 3.0.8 to 4.0 on MS Windoze 98 / PWS (2000)
trouble updating records in database (1998)
removing programming logic white space (2003)
Frames and WebCat (1997)
Document Contains No Data! (1997)
[WebDNA] WebDNA on a cPanel server? Maybe not ... (2019)
searchable list archive (1997)