More Lotto PHP

19:47.23 - Wednesday 3rd March 2004   (Link to This Entry)

I had another look at the PHP Lotto rewrite tonight and found that I hadn't included the part of the results save routine that recompiles all the stats for a draw. Previously I had done this because compiling things in realtime (how many times each ball has been picked, for example) would cause a massive slowdown with ya olde VBScript, but I am of the opinion that PHP and MySQL were going to eliminate that particular problem through sheer speed.

Still, the site would eventually start slowing down at least a little if I let everyone grab those stats and compile their own lists, so I've included the pre-calculation of ball stats in the new version as well. Now when you enter a set of results for draw X and hit save, the site whips through all previous results for that draw type, adds up how many times it's been drawn (with a seperate total for Bonus) and plonks these totals into their own table. Again, I could have had a table for each draw here, but that would be a waste of efford since all records contain the same fields.

So yes, things are still progressing with the rewrite. They've slowed up a bit with the sudden influx of work I have to do, but it'll get there sooner or later.