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:

    
  1. Re: Summary search -- speed (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
  2. Re: Summary search -- speed (Grant Hulbert 1997)
  3. Re: Summary search -- speed (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
  4. Re: Summary search -- speed (Kenneth Grome 1997)
  5. Re: Summary search -- speed (Kenneth Grome 1997)
  6. Re: Summary search -- speed (John Hill 1997)
  7. Re: Summary search -- speed (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
  8. Re: Summary search -- speed (John Hill 1997)
  9. Re: Summary search -- speed (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
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:

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)