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:
PIXO support (1997)
Problem (1997)
Currency Conversion (2003)
WebCat/CyberStudio Compatibility (1998)
Decrypt Acting Strange With Form (2004)
[ShowNext] (1997)
Re:quit command on NT (1997)
WebCatalog NT beta 18 now available (1997)
Item order (2002)
Location of Browser Info.txt file (1997)
multi-paragraph fields (1997)
Help! WebCat2 bug (1997)
append duplication help (2000)
Active Server Code... (1998)
Configuring E-mail (1997)
[OT] (waaaay OT) (2004)
b12 cannot limit records returned and more. (1997)
Which GUI HTML editors work with WC ? (1997)
A little help on e-mail (HELP!!! :-) ) (1998)
searching multiple databases in single search (1997)