Me know logical no need

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41307
interpreted = N
texte = 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 priceI 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/ 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)
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 priceI 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/ Aaron Lynch

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:

[WebDNA] Lookup inside grep?... (2011) Not really WebCat (1997) RE: Problems with shopping cart (1997) problems with 2 tags (1997) taxrate - off by 1 cent (1997) [date format] w/in sendmail (1997) HTML text cannot be copied to clipboard? (1999) adding up in a db (1997) WebCat2b15MacPlugin - [protect] (1997) WebCat2b12 CGI Mac -- Problems propagating the cart through (1997) expired beta (1997) Nested search (1997) [SHOWIF AND/OR] (1997) Sending an email to all )or some) email addresses int he database (1999) Weekly Triggers??? (2000) authenticating a second user (1997) Multiple catalog databases and showcart (1997) taxrate - off by 1 cent (1997) where to put code (1998) in string ??? (2001)