Re: Me know logical no need

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41308
interpreted = N
texte = Do you have SQL Server handy???Wouldn't try this in webcatOn 10/7/02 11:49 AM, Aaron Lynch wrote:> I need some advice on the best way to approach this task, I just can't seem > to wrap my tiny mind around the concepts needed... > > > I have a large real estate DB, currently 35 megs but when this project is > done it will be 500 Megs in size. (every house sold in Seattle for a year) > > I want to find the top 20 listing agents, so for example, the db looks > something like: > > AgentID price > AgentID price > AgentID price > > I think to find the agents with the most actual listings would be easy using > allhit=1&max=20 (right?) > > but, to find who has the most dollar volume, do I need to search all > listings, summarize all the agents, search all the agents, do math into a > temp DB to get a total, and then search the temp DB by total? or is there > (please dear god) an easier way? the full db will be several hundred > thousand records, each 130 or so fields wide. > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/-- Andrew Simpson Web DevelopmentBlackpepper Interactive Ltd PO Box 99805 Newmarket4 Clayton Street Newmarket AucklandPh: +64 9 520-6281 Mob: 0272733270 Fax: +64 9 524-1849http://www.blackpepper.co.nz------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SOLUTION? Re: Me know logical no need (John Peacock 2002)
  2. Re: SOLUTION? Re: Me know logical no need (Jesse Williams-Proudman 2002)
  3. Re: SOLUTION? Re: Me know logical no need (John Peacock 2002)
  4. Re: SOLUTION? Re: Me know logical no need (Brian Fries 2002)
  5. SOLUTION? Re: Me know logical no need (Joseph D'Andrea 2002)
  6. Re: Me know logical no need (Dan Strong 2002)
  7. Re: Me know logical no need (Michael Davis 2002)
  8. Re: Me know logical no need (Aaron Lynch 2002)
  9. Re: Me know logical no need (Michael Davis 2002)
  10. Re: Me know logical no need Now totally OT (Aaron Lynch 2002)
  11. Re: Me know logical no need (Glenn Busbin 2002)
  12. Re: Me know logical no need (Aaron Lynch 2002)
  13. Re: Me know logical no need (Andrew Simpson 2002)
  14. Re: Me know logical no need (Alain Russell 2002)
  15. Re: Me know logical no need (Kenneth Grome 2002)
  16. Re: Me know logical no need (Aaron Lynch 2002)
  17. Re: Me know logical no need (Andrew Simpson 2002)
  18. Re: Me know logical no need (Aaron Lynch 2002)
  19. Re: Me know logical no need (Glenn Busbin 2002)
  20. Re: Me know logical no need (Aaron Lynch 2002)
  21. Re: Me know logical no need (Andrew Simpson 2002)
  22. Re: Me know logical no need (Kenneth Grome 2002)
  23. Re: Me know logical no need (Kenneth Grome 2002)
  24. Re: Me know logical no need (Aaron Lynch 2002)
  25. Re: Me know logical no need (Stuart Tremain 2002)
  26. Re: Me know logical no need (Aaron Lynch 2002)
  27. Re: Me know logical no need (Aaron Lynch 2002)
  28. Re: Me know logical no need (Jesse Williams-Proudman 2002)
  29. Re: Me know logical no need (Jesse Williams-Proudman 2002)
  30. Re: Me know logical no need (Alain Russell 2002)
  31. Re: Me know logical no need (Glenn Busbin 2002)
  32. Re: Me know logical no need (Aaron Lynch 2002)
  33. Re: Me know logical no need (Stuart Tremain 2002)
  34. Re: Me know logical no need (Robert Wade 2002)
  35. Re: Me know logical no need (Alain Russell 2002)
  36. Re: Me know logical no need (Andrew Simpson 2002)
  37. Me know logical no need (Aaron Lynch 2002)
Do you have SQL Server handy???Wouldn't try this in webcatOn 10/7/02 11:49 AM, Aaron Lynch wrote:> I need some advice on the best way to approach this task, I just can't seem > to wrap my tiny mind around the concepts needed... > > > I have a large real estate DB, currently 35 megs but when this project is > done it will be 500 Megs in size. (every house sold in Seattle for a year) > > I want to find the top 20 listing agents, so for example, the db looks > something like: > > AgentID price > AgentID price > AgentID price > > I think to find the agents with the most actual listings would be easy using > allhit=1&max=20 (right?) > > but, to find who has the most dollar volume, do I need to search all > listings, summarize all the agents, search all the agents, do math into a > temp DB to get a total, and then search the temp DB by total? or is there > (please dear god) an easier way? the full db will be several hundred > thousand records, each 130 or so fields wide. > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/-- Andrew Simpson Web DevelopmentBlackpepper Interactive Ltd PO Box 99805 Newmarket4 Clayton Street Newmarket AucklandPh: +64 9 520-6281 Mob: 0272733270 Fax: +64 9 524-1849http://www.blackpepper.co.nz------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Andrew Simpson

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:

WebCat2b12 CGI Mac - [shownext] problem (1997) Problems getting parameters passed into email. (1997) Database Options (1997) WebCatalog for guestbook ? (1997) Is [variable] a Number? (2007) Windows Install issue (2003) WebCat2b13MacPlugIn - [include] (1997) WebCat2 - Getting to the browser's username/password data (1997) thisurl & arguments (2000) More news on 5.0 (2003) Search returns all, not 20 (1997) Writefile outside WebSTAR hierarchy? (1997) NetForms for mail, sorry (1998) Help! WebCat2 bug (1997) Catalog page question (1999) Help- Linux Install Serial number not taling. (2000) PSC recommends what date format yr 2000??? (1997) Quit revisited (1997) question about checkboxes (1999) Where is eudora plugin? (1998)