Welcome Guest
Log In | Register )
You last visited December 18, 2017, 9:44 am
All times shown are
Eastern Time (GMT-5:00)

Huge performance gains for predictions statistics!

Topic closed. 16 replies. Last post 10 years ago by Stack47.

Page 1 of 2
PrintE-mailLink
Todd's avatar - Cylon 2.gif
Thread Starter
Chief Bottle Washer
New Jersey
United States
Member #1
May 31, 2000
24046 Posts
Online
Posted: August 2, 2007, 11:45 pm - IP Logged

I just finished installing substantial performance increases for the prediction statistics pages, including all the statistics reports for each member, and all the Top Predictors reports.

It took a major architectural change to the database and some creative coding to make it happen.  (Anyone who has data warehouse experience may appreciate the difficulty.)

There are now more that 110 million predictions made by all of you (and a few by me Big Grin) stored in the database -- all of which is reported in real-time in the statistics pages.

If you'd like to see the stats in action, click anyone's name and choose "Prediction Statistics".  Or click "Top Predictors" in the Predictions menu.  Try flipping around some of the various options.  Enjoy!

 

P.S. I also added one more thing that I had intended to for a long time.  New predictions are not calculated into the stats until the next day.  That makes the stats more accurate, because with the picks from today in there, they are not balanced against whatever wins the person may get.  By waiting until the drawing has taken place, they are accurate.

 

Check the State Lottery Report Card
What grade did your lottery earn?

 

Sign the Petition for True Lottery Drawings
Help eliminate computerized drawings!

    emilyg's avatar - cat anm.gif

    United States
    Member #14
    November 9, 2001
    31615 Posts
    Offline
    Posted: August 2, 2007, 11:53 pm - IP Logged

    Thanks Todd.  When do you sleep?    Bed

    love to nibble those micey feet.

     

                                 

      Lkydeb*594's avatar - cat anm.gif
      Luv Vtracs 8-)

      United States
      Member #38062
      April 23, 2006
      13258 Posts
      Offline
      Posted: August 3, 2007, 9:06 am - IP Logged

      Thanks Todd.  When do you sleep?    Bed

      I'm wondering the same thing.  When do u ever sleep?  but thank u too. I just can't get enough of your site, I'm loving it! 


        Daniel C's avatar - Kinnak
        Michigan
        United States
        Member #53416
        July 6, 2007
        702 Posts
        Offline
        Posted: August 3, 2007, 11:30 am - IP Logged

        Thank you Todd, for the hard work, dedication and great site.

          spy153's avatar - maren

          United States
          Member #28409
          December 15, 2005
          1198 Posts
          Offline
          Posted: August 3, 2007, 4:38 pm - IP Logged

          thanks Todd, for all your hard work. Thumbs Up

          voir-vous dans mes reves!Cool

            Jake's avatar - animal bird.jpg

            United States
            Member #2217
            September 1, 2003
            986 Posts
            Offline
            Posted: August 3, 2007, 5:43 pm - IP Logged

              Thank you Todd!

              MADDOG10's avatar - smoke
              Beautiful Florida
              United States
              Member #5709
              July 18, 2004
              21154 Posts
              Offline
              Posted: August 3, 2007, 5:49 pm - IP Logged

              Thanks Todd, really cool added features....!

                                                           

                                                             " You can not control the Wind, but you can direct the Sail "

                Fibonacci's avatar - Lottery-050.jpg
                New York, NY
                United States
                Member #39471
                May 16, 2006
                2699 Posts
                Offline
                Posted: August 3, 2007, 5:53 pm - IP Logged

                Before Todd gets sleep... maybe it's just me but i cannot see the new features (or maybe I am doing the wrong thing). Cany anyone pls enlighten us. I am seeing the same stats as before. i cleared my cache so I'm not sure what I am missing.

                $$$

                  Todd's avatar - Cylon 2.gif
                  Thread Starter
                  Chief Bottle Washer
                  New Jersey
                  United States
                  Member #1
                  May 31, 2000
                  24046 Posts
                  Online
                  Posted: August 3, 2007, 6:00 pm - IP Logged

                  Before Todd gets sleep... maybe it's just me but i cannot see the new features (or maybe I am doing the wrong thing). Cany anyone pls enlighten us. I am seeing the same stats as before. i cleared my cache so I'm not sure what I am missing.

                  I did not mention new features -- just speed.  Of course, to anyone who has not seen them before, they would be "new".

                   

                  Check the State Lottery Report Card
                  What grade did your lottery earn?

                   

                  Sign the Petition for True Lottery Drawings
                  Help eliminate computerized drawings!

                    csfb's avatar - Lottery-001.jpg

                    United States
                    Member #15309
                    May 13, 2005
                    307 Posts
                    Offline
                    Posted: August 3, 2007, 9:11 pm - IP Logged

                    That sure is PASSION. Thumbs Up 

                             Sun Smiley             


                      Brazil
                      Member #51781
                      April 24, 2007
                      384 Posts
                      Offline
                      Posted: August 3, 2007, 10:35 pm - IP Logged

                      The speed up is fine. Except, that I am a person that liked the old method ... Anyway, nice work! 

                        NamVet's avatar - army
                        New Member
                        Seattle
                        United States
                        Member #46219
                        September 5, 2006
                        1 Posts
                        Offline
                        Posted: August 3, 2007, 11:31 pm - IP Logged

                        Thanx Todd. Your dedication to this Site is greatly appreciated!!!!

                          Todd's avatar - Cylon 2.gif
                          Thread Starter
                          Chief Bottle Washer
                          New Jersey
                          United States
                          Member #1
                          May 31, 2000
                          24046 Posts
                          Online
                          Posted: August 4, 2007, 2:16 am - IP Logged

                          The speed up is fine. Except, that I am a person that liked the old method ... Anyway, nice work! 

                          The speed is the only thing that changed.  Are you saying you liked it slower?

                          Edit: I guess you're talking about including stats from games that have not been drawn yet.  I like it to be accurate; others may feel otherwise.  I gotta go with my gut on this.

                           

                          Check the State Lottery Report Card
                          What grade did your lottery earn?

                           

                          Sign the Petition for True Lottery Drawings
                          Help eliminate computerized drawings!


                            United States
                            Member #16612
                            June 2, 2005
                            3493 Posts
                            Offline
                            Posted: August 4, 2007, 2:16 am - IP Logged


                            That's a great topic. What causes these predictions to gain so much?

                              fja's avatar - gnome1

                              United States
                              Member #91
                              January 19, 2002
                              12761 Posts
                              Offline
                              Posted: August 4, 2007, 9:35 am - IP Logged


                              That's a great topic. What causes these predictions to gain so much?

                                                            Green laugh

                              "Everybody has to believe in something...I believe I'll have another beer!"   = W.C.Fields