Re: Me know logical no need
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41322
interpreted = N
texte = Why not add a sale to the agents total in the second db at the same time as the sale is recorded in the first dbThat way you would have 15,523 records with sales being updated as sales are made. This way you could have a daily, weekly, monthly, yearly, & total sales fields. -- Stuart Tremain idfk web developments - AustraliaOn Wednesday, 10 July 2002, Aaron Lynch
wrote: >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/ >------------------------------------------------------------- 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:
Why not add a sale to the agents total in the second db at the same time as the sale is recorded in the first dbThat way you would have 15,523 records with sales being updated as sales are made. This way you could have a daily, weekly, monthly, yearly, & total sales fields. -- Stuart Tremain idfk web developments - AustraliaOn Wednesday, 10 July 2002, Aaron Lynch wrote: >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/ >------------------------------------------------------------- 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:
ShipCost Data Base (1998)
Dates - Search and Sorting (1999)
$Replace with [founditems] (1997)
Strange error (2000)
[WebDNA] Code Library (2014)
Mac to Windows (2000)
Best way to upload file.... (2000)
Extended [ConvertChars] (1997)
about this server and links to who (1997)
RE:DatabaseHelper (1997)
Calendar Program (2004)
Help!!!! Purchases not going through! FIXED! (1997)
Frames and WebCat (1997)
pictures / referrer etc. (1998)
Documentation Feedback (1997)
Pass a form (2003)
Date sorting (1997)
SendTo more emails (1998)
WebMerchant - MacAuthorize (1999)
Browser Problem?!? Still getting Error message using POST! (1997)