Re: Me know logical no need
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41358
interpreted = N
texte = The solution is simple, if you get the database every day, then you must have a process that you perform to import the database. During this process, add a process whereby you distill a second database that will be used for your live seller bragging rights calculations. Basically, this second database will be two fields wide, Agent, and Total. At 15,000 agents, this should be a pretty responsive query. Do all the time consumptive searches and calculations just once, when the second db is generated. Logically, since you are only updating a static database once per day, you should only have to do the complex stuff once per day. The sales numbers aren't really live, as the whole database is not really live. This is a blessing more than a curse, so to speak. You don't have to show real-time stats on a live database. That would be much more work. This static, once per day database should make this one aspect of your job easier. If you have other complex searches come up in the project, use the same logical approach. Break complexities out into relational data once per day, then let WebDNA speed through simpler queries as needed.Mike
If you've ever wondered why searching the archives for relevant keywords in the Subject of messages is generally frustrating, take note of the subject of this thread. Who comes up with this sh#!. This thread has a good amount of helpful information in it, but the subject is from another planet. It's completely worthless. I don't even know if a three year old could come up with a subject more inane. On Tuesday, July 9, 2002, at 06:35 PM, Aaron Lynch wrote:> On 7/9/02 6:32 PM, Stuart Tremain mashed the following keys : > >> 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 db >> >> That 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. >> > > >== ------------------------------------------------------------- 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:
The solution is simple, if you get the database every day, then you must have a process that you perform to import the database. During this process, add a process whereby you distill a second database that will be used for your live seller bragging rights calculations. Basically, this second database will be two fields wide, Agent, and Total. At 15,000 agents, this should be a pretty responsive query. Do all the time consumptive searches and calculations just once, when the second db is generated. Logically, since you are only updating a static database once per day, you should only have to do the complex stuff once per day. The sales numbers aren't really live, as the whole database is not really live. This is a blessing more than a curse, so to speak. You don't have to show real-time stats on a live database. That would be much more work. This static, once per day database should make this one aspect of your job easier. If you have other complex searches come up in the project, use the same logical approach. Break complexities out into relational data once per day, then let WebDNA speed through simpler queries as needed.Mike If you've ever wondered why searching the archives for relevant keywords in the Subject of messages is generally frustrating, take note of the subject of this thread. Who comes up with this sh#!. This thread has a good amount of helpful information in it, but the subject is from another planet. It's completely worthless. I don't even know if a three year old could come up with a subject more inane. On Tuesday, July 9, 2002, at 06:35 PM, Aaron Lynch wrote:> On 7/9/02 6:32 PM, Stuart Tremain mashed the following keys : > >> 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 db >> >> That 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. >> > > >== ------------------------------------------------------------- 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/
Michael Davis
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:
WebCat2: Items xx to xx shown, etc. (1997)
Text data with spaces in them... (1997)
[WebDNA] Webcatalog and memory (2011)
View Source from cache (1997)
WebCatalog2 Feature Feedback (1996)
Showif, Hideif reverse logic ? (1997)
A Toughie (1998)
[WebDNA] maybe silly suggestion? [founditems] (2015)
[WebDNA] FindString fails ... but why? (2014)
Help name our technology! (1997)
Associative lookup style? + bit more (1997)
PSC recommends what date format yr 2000??? (1997)
WebDNA for Window 2000 Server (2003)
[SHOWNEXT] Examples (1997)
2 passwords (2003)
Running _every_ page through WebCat ? (1997)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
This message couldn't reach the list! (1998)
Template Security error (1997)
Groups doesn't work (1997)