Hi there,
My name is Shoaib Rehman and I am a Magento freelancer from the UK. I am also working as a professional web application developer in one of the agencies near London.
Talking about the magento database table size, ideally I would try to remove any unwanted extensions to reduce the table size. As a good practice, magento shouldn't have more than 500 tables but I wonder why you have more than 1000 tables?
Share the staging website access with me and I will get on it straight away.
Should you have any questions, please let me know.
I look forward to hearing from you.
Best regards,
Shoaib