Dividing the Database

[modyyy55]

Originally Posted by BirdOPrey5

800 MB is a little big for only 500,000 posts. Do you have attachments and avatars stored in the database (this is the default setting). If so you can follow instructions in the Admin CP to move attachments and avatars to the file system that should bring down your database size...

But 800 MB isn't all that big- if you're running into problems I'd really consider a new server or web host, you shouldn't notice any issues at 800 MB.

Thanks Joe for your reply.


I'm already going to move to a new server in a new company, actually I'm transfering the data right now :D.

But I'm afraid that this database will expand and will need me to upgrade the server every while even if the active members on the forum are the same, that what I'm afraid of.

So I thought that dividing the database could help, is there a way for that ?


I have already moved the attachments outside of the database, will try to do that for avatar too, but the problem is that the posts table is 400 MB it self, it's the largest table in the database.