Re: Summarizing results. Is there a shortcut?

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24843
interpreted = N
texte = Joseph,the simple way is to make a new database that has one record per day, and do the summary into that DB using a trigger once per day for the previous day.On 28/11/99 4:01 AM, Joseph D'Andrea said:>My merbership database is about 9,000 records in size at the moment. It is >currently growing by ~100 records each day. Some of the fields in the >database are: CreationDate and LastLoginDate. > >I have an administrative search that I like to look at to see how sign-ups >and logins are progressing. So I want to be able to see, for example, how >many people signed on since we began operation. (80 days ago). > >I do this in my search page: > > >[search >db=name.db&neLoginDatedata=0&logindatesort=1&logindatesdir=de&logindatesum >m=T&lo >gindatetype=date&startat=1] >[numfound] days in operation >[founditems] >[search db=MRNprofile.db&eqlogindatedata=[logindate]&logindatetype=date] > >[math >>show=t]runningtotal=[runningtotal]+[numfound][/math][logindate] >[numfound] >>BORDER=0> >[/search] >[/founditems] >[/search] > >The outside search searchs for all the unique dates in the database and >then the inside search counts the number of records that match that date. > >This process currently takes ~10 seconds to complete. > >The problem is that the server stops serving other requests during this >period. While that's not a problem now, it may be in the future. And while >this is completely preventable (ie: I don't have to run the report, or I >can run the report at off hours via a trigger.)... I'm wondering if there >is some other way that I can get the number of items that match the unique >value without having to do a second search. > >Any thought? > >___Joe___ > > >_________________________________________________ >Joseph D'Andrea JoeDan@West21.com >WEST21.com Internet services for the 21st Century > http://www.west21.com/ >_________________________________________________ > > > > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to . > >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 > Thomas Wedderburn-Bisshop Technical Director Woomera Net Solutions www.woomeranet.com.au Sydney, Australia Phone +61 2 9746 0700 fax +61 2 9751 6941 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. FEATURE REQUEST: (was: Summarizing results. Is there a shortcut? (Joseph D'Andrea 1999)
  2. Re: Summarizing results. Is there a shortcut? (Thomas Wedderburn-Bisshop 1999)
  3. Summarizing results. Is there a shortcut? (Joseph D'Andrea 1999)
Joseph,the simple way is to make a new database that has one record per day, and do the summary into that DB using a trigger once per day for the previous day.On 28/11/99 4:01 AM, Joseph D'Andrea said:>My merbership database is about 9,000 records in size at the moment. It is >currently growing by ~100 records each day. Some of the fields in the >database are: CreationDate and LastLoginDate. > >I have an administrative search that I like to look at to see how sign-ups >and logins are progressing. So I want to be able to see, for example, how >many people signed on since we began operation. (80 days ago). > >I do this in my search page: > > >[search >db=name.db&neLoginDatedata=0&logindatesort=1&logindatesdir=de&logindatesum >m=T&lo >gindatetype=date&startat=1] >[numfound] days in operation >[founditems] >[search db=MRNprofile.db&eqlogindatedata=[logindate]&logindatetype=date] > >[math >>show=t]runningtotal=[runningtotal]+[numfound][/math][logindate] >[numfound] >>BORDER=0> >[/search] >[/founditems] >[/search] > >The outside search searchs for all the unique dates in the database and >then the inside search counts the number of records that match that date. > >This process currently takes ~10 seconds to complete. > >The problem is that the server stops serving other requests during this >period. While that's not a problem now, it may be in the future. And while >this is completely preventable (ie: I don't have to run the report, or I >can run the report at off hours via a trigger.)... I'm wondering if there >is some other way that I can get the number of items that match the unique >value without having to do a second search. > >Any thought? > >___Joe___ > > >_________________________________________________ >Joseph D'Andrea JoeDan@West21.com >WEST21.com Internet services for the 21st Century > http://www.west21.com/ >_________________________________________________ > > > > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to . > >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 > Thomas Wedderburn-Bisshop Technical Director Woomera Net Solutions www.woomeranet.com.au Sydney, Australia Phone +61 2 9746 0700 fax +61 2 9751 6941 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Thomas Wedderburn-Bisshop

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:

Price override (2004) Database Import/Export (1998) Email Problem (1997) PCS Emailer's role ? (1997) Country & Ship-to address & other fields ? (1997) Where's Cart Created ? (1997) Redirect frame targets (1998) WebCat2b13MacPlugIn - [include] (1997) SERIAL NUMBER PROBLEM *AGAIN*!!! (1998) [no_cache]?! (2000) Test (2003) Re:PCS Customer submissions ? (1997) OT: Let's see your workspace... (2005) # fields limited? (1997) IASPI_Rewrite & WebDNA (2007) [WriteFile] problems (1997) security (1997) (1997) Need some Java Script Code (2003) createfolder not behaving as expected (1999)