search

TechLevelZero / doddlebot

doddlebot for doddlecord
https://discord.gg/Dzzzqht
3 stars 0 forks source link

DB optimisation for member data #33

Closed TechLevelZero closed 5 years ago

TechLevelZero commented 5 years ago

Currently member data is all over the place, points are in one table and weeklypoints in another. Intro data is in another table.

This all needs to be sorted in to one table so when needing to get internal member data it is all in one table.

TechLevelZero commented 5 years ago

Most member data has been transferred and have removed points from people who have left. But there is 100 members missing, its not a big deal as there data has never been stored before but would be nice to have all members data so there are no undefined errors with user data.

TechLevelZero commented 5 years ago

member data has been transferred and table optimisation has been done.

This has been running for about 2 weeks on stable and have removed any correlation errors between the Table and the bot.