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 seemto wrap my tiny mind around the concepts needed...I have a large real estate DB, currently 35 megs but when this project isdone 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 lookssomething like:AgentID priceAgentID priceAgentID priceI think to find the agents with the most actual listings would be easy usingallhit=1&max=20 (right?)but, to find who has the most dollar volume, do I need to search alllistings, summarize all the agents, search all the agents, do math into atemp 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 hundredthousand 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:
I need some advice on the best way to approach this task, I just can't seemto wrap my tiny mind around the concepts needed...I have a large real estate DB, currently 35 megs but when this project isdone 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 lookssomething like:AgentID priceAgentID priceAgentID priceI think to find the agents with the most actual listings would be easy usingallhit=1&max=20 (right?)but, to find who has the most dollar volume, do I need to search alllistings, summarize all the agents, search all the agents, do math into atemp 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 hundredthousand 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)