Predictions system work needed over the next few months
I assumed it will be a good suggestion to start a conversation about some work that I’m going to be wanting to do on the predictions system over the next few months, as a result of sooner or later the predictions system will want to be introduced offline quickly to make some adjustments that I’m going to talk about underneath.
The drawback is that once I created the predictions system 15 years in the past I didn’t await that I might want to construct a database that will dangle greater than 2 billion prediction selections. But now I will be able to see that it’ll exceed that many selections inside of the next few years. Without making adjustments, the predictions system will merely forestall running at the level that it exceeds its capability.
In addition, on account of the sheer quantity of information that I’m supporting in the database, and since the predictions information is housed in the similar database as the remainder of Lottery Post, it’s just about not possible to make any adjustments as a result of doing so would bathroom down the database server such a lot that the website online would in reality grow to be unusable.
So it has grow to be a beautiful vital mission to by some means pull the huge set of predictions information out of the major Lottery Post database, and at the similar time re-architect it in order that it might fortify greater than 2 billion predictions. And I want to do this in some way that the major Lottery Post site by no means comes offline. Fairly difficult!
I’ve get a hold of a pair alternative ways of doing it, however in each and every approach there’s a sure level the place it turns into essential to take the predictions system offline whilst the ultimate levels of the cut-over to a brand new database would happen. The downtime would perhaps be lower than someday, however as a result of there’s downtime concerned I assumed you will want to talk about it with you all.
We’re no longer speaking about one thing that will happen day after today, however you must get started making plans now. I do not wish to wait to lengthy to do that needed work.
If you had to make a choice an afternoon of the week for the predictions system to come back offline, what day of the week would YOU pick out?
Are there another issues I must be fascinated by?