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:
default value from Lookup (was Grant, please help me) (1997)
authorize.net CC processing (was WC on Mac OS X or Mac OS (2001)
Custom Shipping Charges (1997)
using showpage and showcart commands (1996)
Question about replacing words (1998)
Search design (1997)
[WebDNA] Sending 100 mails an hour then pausing (2010)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
NT b19 sends extra MIME headers (1997)
Frames and WebCat (1997)
HELP WITH DATES (1997)
Authenticate (1997)
Credit Card not accepted (1998)
Pass a form (2003)
Never ending problem.... (2000)
shownext not showing next...still r2 (1997)
Help! WebCat2 bug (1997)
WebCat2 - storing unformatted date data? (1997)
[WebDNA] bring back PORT feature! (2017)
can pull down menu do a ONCHANGE= without Java script? (2000)