Multistores Database Splitting -

[Crazyweb]

Hi,

 

I have been using Prestashop Multistore for a few years now and just today I received an email from my hosting letting me know my database is becoming to big. 

 

I'm hosting from Godaddy and the  DB limit is 1 GB. My DB is 2 GB. I emptied all additional data in de DB such as ps_guest - ps_connectect and a few others.

 

I see that the Search index is and search words are using more than 50% of the DB size. I use 6 languages and have about 5k products.

 

Solution A:

 

Move to another host - I found a host with no limit on the DB - but a limit on the traffic. For now this would solve my problem.

 

Solution B:

Godaddy suggested to split the database. Is this even possible and will the stores still be running?

 

Solution C:

 

Split the amount of stores that run on one DB to reduce the DB size and traffic and create a second multistore

 

Can somebody give me advise on this.