Re: Me know logical no need
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41311
interpreted = N
texte = Or run a second db-- Stuart Tremainidfk web developments - AustraliaOn 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/
Associated Messages, from the most recent to the oldest:
Or run a second db-- Stuart Tremainidfk web developments - AustraliaOn 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/
Stuart Tremain
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:
Missing custom convert.db (1998)
can include param variables be valid [math] players? (2000)
Emails sent twice (2000)
WebDNA Solutions ... (1997)
Can you do this??? and other stuff (1997)
Re:What file? (1997)
[ModDate] & [ModTime] ? (1997)
fresh eyes needed. Append won't work. (2000)
[listfields] context (2005)
no global [username] or [password] displayed ... (1997)
Limit on nested [ShowIf]'s? (1997)
Size limit for tmpl editor ? (1997)
Quitting WebMerchant ? (1997)
Resume Catalog ? (1997)
mail list (1998)
Showif for mulitple variations (1997)
Creating folders and deleting files (1997)
Strange intermittent WebDNA problems (2008)
RE: protect tag on NT (1997)
Finalizing Orders (2000)