Multi DB Question About Affiliate DB Tables

Hello There

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:

affiliatedata
affiliaterecords
affiliatereferrers

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
Mark bloglines.co.za