Summarizing results. Is there a shortcut?
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 24841
interpreted = N
texte = 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&logindatesumm=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] |  |
[/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
Associated Messages, from the most recent to the oldest:
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&logindatesumm=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] | |
[/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
Joseph D'Andrea
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:
Looking for WebCat web hoster in Chicago/Illinois/Midwest (2000)
webcat method for waiting specific amount of time? (2000)
Cancel Subscription (1996)
Multiple download orders of the same product? (1997)
Problem with version 4 browsers (1998)
WebDNA Developer Resource Center (2002)
Shipping formula problem (1997)
WebCat Bulletin Board Solution ? (1998)
No luck with taxes (1997)
pc (1997)
[WebDNA] New Mountain Lion OSX Server (2013)
RE: what characters are replaced for tab and CR? (1998)
Possible Bug in 2.0b15.acgi (1997)
Shopping Cart Limits? (1998)
[WebDNA] Cloud Server install notes - Ubuntu 14.04 (2018)
Searchable WebCat (etc.) Docs ? (1997)
More on the email templates (1997)
Frames and WebCat (1997)
Nesting Search Within ![]()
Tag? (1997)
Count regular expressions in a file (2007)