Installation and deployment Questions on installation, system configuration and deployment to the live server.
Version 4.x > Installation and deployment > Minimizing installation View modes: 
User avatar
Member
Member
michielvoo - 4/27/2009 3:38:04 AM
   
Minimizing installation
Hello,

our client uses shared hosting with a maximum database site of 20MB. For a 40MB database the price for hosting doubles. Kentico CMS standard install is already 30MB. How can we minimize the size of the database?

Maybe we could edit the file defaultData.txt in the App_Data\Install\SQL folder? Would it still be possible to add features later?

Thank you!

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 4/28/2009 7:53:08 AM
   
RE:Minimizing installation
Hi,

It is not recommended to remove anything from the DB. Moreover, in these days only 20MB for database? That is too little. Even if you will be able to make the DB smaller that 20DB, you will need to add some documents or images and you will exceed this limit.
20MB can be anough for some personal site with few documents, but not for CMS system.

I would like to recommend you to find another hosting. Here you can find our hosting partners.

Best Regards,
Juraj Ondrus

User avatar
Member
Member
michielvoo - 4/29/2009 4:56:25 AM
   
RE:Minimizing installation
Yes, 20MB for a database! That's is indeed too little... for Kentico. The reason it works like that, is because the bigger the databases, the more database servers the hoster needs to install, so licencing costs go up.

I have managed to get the database of Kentico down to 12 MB by not installing webparts, metafiles, countries and states, badwords and email templates. But it will start to bloat once I create a site.

I see two solutions:

1. Storing files (images, PDFs etc) on disk.
2. Using a MySQL database (up to 400MB without added cost in our case).

Are these things possible?

User avatar
Kentico Developer
Kentico Developer
kentico_ondrejv - 4/29/2009 9:40:33 AM
   
RE:Minimizing installation
Hello,

Regarding your solutions:

1. Yes, it's possible to store files in database. It will enforce your database will not grow so fast. Also the performance will be better.

2. Unfortunately MySQL database is not supported. You can use only following databases: Microsoft SQL Server 2000, 2005, 2008 (including free SQL Server Express Edition)

Best regards
Ondrej Vasil