Re: Me know logical no need
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41313
interpreted = N
texte = Right, this was my initial idea too, a second db.I get the entire DB daily, I never add records, it comes from the MLS. So a running total would require 300,000+ replaces.A second DB, ditto.I could do as suggested and search all agent's (15,523 of them) and then summarize the total, but, again, that's 1+ 15,523 searches :)I'm thinking that'll be slow. On 7/9/02 5:16 PM, Stuart Tremain mashed the following keys :> Or run a second db > -- > Stuart Tremain > idfk web developments - Australia > > On Wednesday, 10 July 2002, Robert Wade
wrote: >> Would it be possible for you to add a field to the database that would keep a >> running total for each realtor. Every time a listing is added you look at >> the last >> running_total field in the listing for that agent, then add the cost of the >> new >> one to that total and stick it in the new listing's field. Since all the >> entries >> are added into the database chronologically, it would then be simple to do a >> summarized agentID search by most recent date to figure out who has the >> highest >> running_total. You could total up each agents entries as of now, and enter >> that >> into the last entries running_total field for that agent. No need to go >> back and >> do the math for each entry, since all you need is a total, then the script >> would >> take care of it from here. >> >> Just a thought... RW >> >> Andrew Simpson wrote: >> >>> Do you have SQL Server handy??? >>> >>> Wouldn't try this in webcat >>> >>> On 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 Development >>> >>> Blackpepper Interactive Ltd >>> PO Box 99805 >>> Newmarket >>> >>> 4 Clayton Street >>> Newmarket >>> Auckland >>> >>> Ph: +64 9 520-6281 >>> Mob: 0272733270 >>> Fax: +64 9 524-1849 >>> >>> http://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/ >> >> -- >> >> ================================================ >> Robert Wade >> Outbound Creative, Inc. >> robert@outboundcreative.com >> ================================================ >> |[ ] L|| ‘||‘ ||} |[ ] L|| ||\| ||) >> ================================================ >> >> >> >> ------------------------------------------------------------- >> 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/ >> > > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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:
Right, this was my initial idea too, a second db.I get the entire DB daily, I never add records, it comes from the MLS. So a running total would require 300,000+ replaces.A second DB, ditto.I could do as suggested and search all agent's (15,523 of them) and then summarize the total, but, again, that's 1+ 15,523 searches :)I'm thinking that'll be slow. On 7/9/02 5:16 PM, Stuart Tremain mashed the following keys :> Or run a second db > -- > Stuart Tremain > idfk web developments - Australia > > On Wednesday, 10 July 2002, Robert Wade wrote: >> Would it be possible for you to add a field to the database that would keep a >> running total for each realtor. Every time a listing is added you look at >> the last >> running_total field in the listing for that agent, then add the cost of the >> new >> one to that total and stick it in the new listing's field. Since all the >> entries >> are added into the database chronologically, it would then be simple to do a >> summarized agentID search by most recent date to figure out who has the >> highest >> running_total. You could total up each agents entries as of now, and enter >> that >> into the last entries running_total field for that agent. No need to go >> back and >> do the math for each entry, since all you need is a total, then the script >> would >> take care of it from here. >> >> Just a thought... RW >> >> Andrew Simpson wrote: >> >>> Do you have SQL Server handy??? >>> >>> Wouldn't try this in webcat >>> >>> On 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 Development >>> >>> Blackpepper Interactive Ltd >>> PO Box 99805 >>> Newmarket >>> >>> 4 Clayton Street >>> Newmarket >>> Auckland >>> >>> Ph: +64 9 520-6281 >>> Mob: 0272733270 >>> Fax: +64 9 524-1849 >>> >>> http://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/ >> >> -- >> >> ================================================ >> Robert Wade >> Outbound Creative, Inc. >> robert@outboundcreative.com >> ================================================ >> |[ ] L|| ‘||‘ ||} |[ ] L|| ||\| ||) >> ================================================ >> >> >> >> ------------------------------------------------------------- >> 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/ >> > > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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:
Search in 2 or more catalogs (1997)
multiple replace sku data (2003)
Protect Tage and Groups (1998)
autosensing lanague selection (1997)
Folder Follies (1998)
help with autenticate (1998)
Need help with emailer- 2 issues (1997)
Future of WebDNA (was urls) (2005)
Sorta OT: Printing From Browser Window (2001)
[WebDNA] Finding duplicate email addresses (2008)
Re:Removing items from a cart is wonky... (1998)
WebDNA Feature Request (2006)
not interpreting Q (2001)
More DateMath problems (1997)
WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997)
[writefile] remotely (2000)
I need hosting (2003)
Re[3]: 2nd WebCatalog2 Feature Request (1996)
Not really WebCat (1997)
[delete] problem (1997)