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:
WebCat and WebTV (1997)
searches with dash, period etc. (2000)
using showpage and showcart commands (1996)
Bug Report, maybe (1997)
Protecting Images (2003)
time + (1998)
[platform] tag? (1998)
OS X problem: when using [ShowCart] or [orderfile]... (2000)
Install problem (Was Bad Install) (2003)
lookup limitation ? (2003)
Need help!! on searching in two databases. (1998)
Bill To - Ship To Information display (1997)
SOP for WebDNA talk (2004)
Speed/performance issues using .hdr (1997)
RE: redirect with more than 256 characters (1999)
WC Database Format (1997)
Robots fill event log (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Exclamation point (1997)
credit card authorization question (1997)