As someone on the inside would know, the bank… The bank needs to be changed. It was good originally with Google Sheets but it has become just a monster. It is far too large for sheets to handle. With the league larger than ever it’s time to make a change. The current bank sits at 32,561 archived transactions and 13,974 current transactions. The archived transactions log doesn't need to be processed everytime a new transaction is done, however the current transactions table does a query to update everyone’s current balance each and every time. There is also a column that updates every time to make sure you have enough money to make the transaction so the banker doesn't have to check each time. The archived transactions table is 981 days worth of transactions which calculates to ~33.2 transactions per day. That being said the current transactions table only being 161 days old calculates to ~86.8 transactions per day. That is a huge contrast. There has been such an influx of new players that the bank would need to be archived every 6 months or less as opposed to the current which was twice in the last 3 years. Time to get the bank off of sheets and into a real database.
![[Image: 26alt.png]](https://9cherry.com/images/26alt.png)