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-BisshopTechnical DirectorWoomera Net Solutions www.woomeranet.com.auSydney, 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:
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-BisshopTechnical DirectorWoomera Net Solutions www.woomeranet.com.auSydney, 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)