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 SimpsonWeb DevelopmentBlackpepper Interactive LtdPO Box 99805Newmarket4 Clayton StreetNewmarketAucklandPh: +64 9 520-6281Mob: 0272733270Fax: +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:
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 SimpsonWeb DevelopmentBlackpepper Interactive LtdPO Box 99805Newmarket4 Clayton StreetNewmarketAucklandPh: +64 9 520-6281Mob: 0272733270Fax: +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)