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 thensummarize 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 thensummarize 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:
[convertChars] and in a textarea on a form (1998)
SiteEdit NewFile.html ? (1997)
WebCatalog2 Feature Feedback (1996)
Re:Remote stockroom ? (1998)
WebCat2 beta 11 - new prefs ... (1997)
(2000)
WebCat b13 CGI -shownext- (1997)
WC 2.0 frames feature (1997)
Newbie questions (1999)
WebCat2_Mac RETURNs in .db (1997)
webcat, osx, and includes (2001)
target=_blank and form variables (1997)
Need relative path explanation (1997)
Erotic Sites (1997)
WebCat2 - [format thousands] (1997)
WebCatalog/Mac 2.1b2 New Features (1997)
Hiding HTML and breaking the page (1997)
Most likely trivial but I'm perplexed (2000)
Append..... doesn't (2000)
webcat 2.1 (1997)