I would like to ask if there was not a better way of doing this :slight_smile:
I looked trough my DB Shards 4096 + 2 and in ever one i see a tables called:
I am not a DBA although i mess with the dbs to keep them clean.
SO recap there:
affiliatedata 4096 rows of wasted space in the db
affiliaterecords 4096 rows of wasted space in the db
affiliatereferrers 4096 rows of wasted space in the db
That is a total of 12288 rows of wasted space is it just me or is that a lot of stuff the poor MySql server have to trough just to make sure the user is a affiliate or not.
Now My suggestion is easy to say but super hard to do just have 3 tables in the Global DB and that is it, this way global gets hit and not the “blog” dbs.
Again just thoughts as i am not a DBA :slight_smile:
Thank you Kindly