Re: Summary search -- speed

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12126
interpreted = N
texte = The summary search command appears very useful for pulling out unique fields, such as the categories in the Tea Room example that ships with 2.0. I'm wondering what type of speed this summary search command has over large databases. If the inventory was in the 100K records range, would there be a significant speed hit for a unique entry summary search? Would I be better off with a separate data table that kept a unique list of categories, etc? I don't yet have the large inventory database to play with, but I need to plan ahead for it.ThanksSandy 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)
The summary search command appears very useful for pulling out unique fields, such as the categories in the Tea Room example that ships with 2.0. I'm wondering what type of speed this summary search command has over large databases. If the inventory was in the 100K records range, would there be a significant speed hit for a unique entry summary search? Would I be better off with a separate data table that kept a unique list of categories, etc? I don't yet have the large inventory database to play with, but I need to plan ahead for it.ThanksSandy Sandra L. Pitner <76501.3521@CompuServe.COM>

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:

StoreBuilder Q's (2003) Erotic Sites (1997) turning every 5th line red (1999) Emailer Timing out (1999) Funny Submissions From a Form Page (1999) decrypt and summ problems (1999) Re:Add (1998) Upcoming 2.1 Release and PCS Committment (1997) PSC recommends what date format yr 2000??? (1997) [WebDNA] WebDNA fastCGI beta versions (2010) Drop Down Menu from comma delimited values. (2002) ListFields and [name] (1997) Need example sites for seminar; will plug you too (1998) [MATH] and Dates (1998) Snake Bites (1997) Get Cookie problem..... (2000) default value from Lookup (was Grant, please help me) (1997) no template caching (1997) Download (1999) [WebDNA] Bug in [thisurlplusget] on v7 (2011)