I am not an expert in joomla, and dont know much about database performance. So I would like to clear some doubt and get some suggestion before designing a big site. I am building a community driven site with jomsocial, which will used to make profile, events, and will not be extensively used like facebook. Will have directory with peak of 10000+ articles in first 6 months and will not exceed 20k since I'll delete previous ones. This becomes core component along with some other articles. Also there will be a blog, which will have post frequency of one articles a day with expected 250 articles in 6 months. Here are my some question: 1. How much appx. database size will it make in about 6 and 12 months. 2. Can I a use all jomsocial, mosets tree and blog under same installation. Since it would be better for me to maintain . Does it will hamper site performance ? 3.Will VPS will be able to handle this site in the beginning or should I go for Dedicated server right form the beginning. Suggestion are much appreciated. Would like to hear your experience with large site like above. Thank You
Hard Question. The Problem - Joomla can do all that, but with huge amount of database capacity. You should have an own, fast server. With Databases on SSD (better everything on SSD) and DB-Caching on. Your provider will give you information. If you have such a big website where the contents are not cached when the Users are logged in and the Users are very active it can be easy to have some millions of Database requests per minute. One Page with some custom Joomla components in the Installation can make 340 Database requests, easily! It sounds like your database will grow up to some GB. If you have a power machine as Server and caching/CDN on for the bots and unknown visitors, this could work.