Re: Me know logical no need
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41316
interpreted = N
texte = I would have thought anything you did with a 500 MB database would be slow .. ?> 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:
I would have thought anything you did with a 500 MB database would be slow .. ?> 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/
Alain Russell
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:
Emailer setup (1997)
.. more on sliding discounts... (1997)
WebCat Redundancy (2000)
WC Host Needed (2000)
[format] question (2000)
international time (1997)
WAP (2000)
I'm having trouble using [url][interpret][math] together inlookup (1997)
[Sum] function? (1997)
default value from Lookup (1997)
price on detail, but not shoppingcart (1997)
autosensing lanague selection (1997)
Couple of questions (1999)
Listfiles (1998)
Cart -> Date and Time (2004)
[include file=filename.inc&strip=t] (2002)
Search technique question (1998)
Search design (1997)
Trigger Problems (2001)
Re:Emailer setup (1997)