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:
WCS Newbie question (1997)
Size limit for tmpl editor ? (1997)
RequiredFields template (1997)
Need a little help with categories... (2003)
Customer - again (1998)
RE: [sendmail]- bcc? (1998)
Summing fields (1997)
How do I access a shopping cart once it had been moved intothe Completed Orders folder? (2000)
Formatting time output (2000)
[WebDNA] Friday Fun with Variable Names (2017)
Shopping Carts (2000)
select multiple (1997)
Showing unopened cart (1997)
Weird bug, or is there something amiss? (1997)
log out (2001)
quit command on NT (1997)
WebCatalog can't find database (1997)
Sample Tearoom Search Error (1997)
Its not that weird. (1997)
Caching [include] files ... (1997)